What is the difference between Drop and Truncate
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 instances when triggers are appropriate?
What is scalar user-defined function?
What according to you is the difference between mysql and sql server performance?
What do you mean by a Composite primary key?
Explain transaction server auto commit?
What is named query? : sql server analysis services, ssas
How to create new tables with "select ... Into" statements in ms sql server?
Explain about Views?
What are the differences between left join and inner join in sql server?
What is the difference between ddl and dml?
Explain temporary table vs table variable by using cursor alternative?
What are the different methods available under sqlcommand class to access the data?
What is meant by datasource?
How to delete duplicate rows from table except one?
What do you mean by acid?