what is the difference between delete and truncate?
- 4 Answers
- 5945 Views
- I also Faced
- E-Mail Answers
Answer Posted / venkatesh kumar.s
Truncate:The truncate command deletes the rows in the
table,but not the structure of the table.
Cmd-truncate table tablename;
Drop:The drop command will drop the table from the databases.
Cmd-drop table tablename;
Delete:The delete cmd removes tuples from a relation.It
includes where clause to select the tuples to be deleted.
Cmd-delete from tablenmae where attribute-name="value" or value;
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
What is a checkpoint in dbms?
When we will denormalize data?
State some commands of ddl in dbms?
What do you mean by cardinality and its types?
How do you link a spreadsheet to a website?
How can I access my database remotely?
What is a file in a database?
How is the pattern matching done in the sql?
Which software is best for database?
What is the purpose of sql?
What are the basic components of notification services?
How do you call a stored procedure from jdbc?
How do you organize a database?
Explain what is a deadlock and mention how it can be resolved?
List few disadvantages of file processing system.
