Interested to Buy Any Domain ? << Click Here >> for more details...
what is the difference between delete and truncate?
- 4 Answers
- 7075 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 rdbms data?
What are the types of tables in database?
how you will identify the mapping level bottleneck ? if there is a mapping level bottleneck then how will you try to improve the mapping
What is a relation schema?
What restrictions can you apply when you are creating views?
Describe the types of keys?
Why is maintaining a database important?
What are 4 types of models?
Explain the importance of database partitioning.
What are the disadvantages of a database?
Is it good to store image in database?
How do convert or display the date or time as string?
Can we use GO_BLOCK package in a PRE_TEXT_ITEM trigger ?
What is the best database to use?
What is tuple and attribute?
