Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between Drop and Truncate
- 20 Answers
- 37026 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
How can I tell if sql server is 32 or 64 bit?
What are differences in between sql server 2012 and sql server 2016?
What do you understand by integration services in sql server?
What are the basic functions for master, msdb, model, tempdb and resource databases? : SQL Server Architecture
Can group functions be used in the order by clause in ms sql server?
What is built-in/administrator?
What are the properties and different types of sub-queries?
What command do we use to rename a db, a table and a column?
What is onf in normalization form?
Can a unique index be created on a column, which contains null?
How to create a view and a stored procedure in ms sql server using "create view/procedure" statements?
What are security principals used in sql server 2005?
How self join is different from outer join?
What is the syntax to execute the sys.dm_db_missing_index_details?
What is nested transaction?
