What is the difference between Drop and Truncate
- 20 Answers
- 32082 Views
- GT Nexus, IBM, I also Faced
- E-Mail Answers
Answer Posted / lakshmi
Drop can be used to drop the entire table including data
and structure of table where as truncate removes rows from
table but the structure of table remains as it is.
| Is This Answer Correct ? | 18 Yes | 1 No |
Post New Answer View All Answers
Why truncate is ddl?
How do I find the port number for sql server?
What is 'Join' and explain its various types.
How many cores do I need for sql server 2016?
What is a unique index?
How to rename databases in ms sql server?
Tell me what do you understand by a view? What does the with check option clause for a view do?
How can you find out which stored procedures are recompiling?
Can we insert data if clustered index is disabled?
Which tools are available to manage SQL Azure databases and servers?
What is the federation in sql azure?
What are logical/boolean operations in ms sql server?
How to rename an existing column with the "sp_rename" stored procedure in ms sql server?
What are the built in functions in sql server?
How to drop an existing stored procedure in ms sql server?
