Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between Drop and Truncate
- 20 Answers
- 37034 Views
- GT Nexus, IBM, I also Faced
- E-Mail Answers
Answer Posted / ferolin j
DROP TABLE- all the relationships with other tables will
no longer be valid, the integrity constraints will be
dropped, grant or access privileges on the table will also
be dropped, if want use the table again it has to be
recreated with the integrity constraints, access privileges
and the relationships with other tables should be
established again.
TRUNCATE TABLE- the table structure remains the same, ONLY
deletes the data.
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
How to connect Azure federated root database and apply federation in entity framework?
You notice that the transaction log on one of your databases is over 4gb the size of the data file is 2mb what could cause this situation, and how can you fix it?
What are logical/boolean operations in ms sql server?
Can a cursor be updated? If yes, how you can protect which columns are updated?
why does a sql statement work correctly outside of a user-defined function, but incorrectly inside it? : Sql server administration
What are exact numeric data types in ms sql server?
What is difference between count (*) and count 1?
What are the properties of the transaction?
what types of replication are supported in sql server? : Sql server database administration
Introduction of rollup clause using sum and group by clause?
How to populate a table in sql server?
What is dbcc?
Where the sql logs gets stored? : sql server database administration
What is the difference between Stored Procedures and triggers?
How to delete exactly duplicate records from a table?
