Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between Drop and Truncate
- 20 Answers
- 37880 Views
- GT Nexus, IBM, I also Faced
- E-Mail Answers
Answer Posted / satyanarayana
Drop and Truncate commands both are DML commands.
If we use drop command it will deletes all the table data
as well as tablestructure.But if we use truncate command it
will deletes the table data only.
| Is This Answer Correct ? | 24 Yes | 44 No |
Post New Answer View All Answers
What is the use of partition by in sql server?
How many clustered indexes there can be on table ?
How to get a list of all tables with "sys.tables" view in ms sql server?
Can truncate be rolled back?
Tell me what is log shipping?
What is the difference between drop table and truncate table?
Do you know what is raid and what are different types of raid configurations? : SQL Server Architecture
What is global temp table?
How do I delete a sql server database?
What is indexed view? How to create it?
Do you know what is difference between index seek vs. Index scan?
What do you mean by acid?
What is side by side migration in sql server?
What are the various Operating system files that every SQL server 2005 database has and what is the purpose.
What is the difference between a local and a global temporary table?
