Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between Drop and Truncate
- 20 Answers
- 37607 Views
- GT Nexus, IBM, I also Faced
- E-Mail Answers
Answer Posted / suman kalyan betal
DROP means it's drop the table(with rows,Pk_key, Fk_key and
indexces)from the database.
TRUNCATE do the same as DROP but maintain the Pk_key,
Fk_key and indexces declaration only remove rows.
---by suman kalyan betal (suman_kal@rediffmail.com)
| Is This Answer Correct ? | 9 Yes | 3 No |
Post New Answer View All Answers
What are the differences between stored procedure and view in sql server?
What are the different SQL Server Versions you have worked on?
What are the system database in sql server 2008?
What are the types of database recovery models?
What new changes are being made in SQL Server?
What are the authentication modes in sql server? How can it be changed?
Explain the working of sql privileges?
How do I clean up sql server transaction log?
What are the types of database schema? : sql server analysis services, ssas
Where can you add custom error messages to sql server?
What will be query used to get the list of triggers in a database?
Write a sql query to delete duplicate records from a table called table1
Explain what is the purpose of sql profiler in sql server?
How to generate create table script on an existing table in ms sql server?
How to override dml statements with triggers?
