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 is user-defined scalar function?
Give an example of SQL injection attack ?
How to change a login name in ms sql server?
What happens if the update subquery returns multiple rows in ms sql server?
Does group by or order by come first?
What does it mean if @@cursor_row returns a negative number?
How to create hyperlink from returned sql query ?
What are character string data types in ms sql server?
How do I open port 1433?
what are the reporting service components in SSRS?
Can you please explain the difference between primary keys and foreign keys?
How does SSIS(Sql Server Integration Services) deffer from DTS(Data Transformation Services)?
Where views are stored in sql server?
Which database stores information about replication?
How to turn on the mssql api module in php?