what is the difference between delete and truncate?
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 database definition (dbd)?
Explain the syntax of named procedure?
How to select a random record from a table?
What are partitions in database?
What is a database management system and give examples?
What do you mean by starvation in dbms?
What are indexes? Mention the differences between the clustered and non-clustered index?
Is google scholar a database?
Is there some bulk load or other way to import a lot of data fast?
What are the various normalizations in database?
What are the different types of database?
Explain what are super servers?
Have you written applications to retrieve stored images in a table?
What do you understand by join?
Explain what are triggers and rules?