What is difference between TRUNCATE and DELETE statement
- 12 Answers
- 20272 Views
- CTS, I also Faced
- E-Mail Answers
Answer Posted / xyz
truncate basically clears the data from the rows of a
specified colomn.
e.g. truncate colomn_name from table_name
then this will only empty the colomn
delete is used to simpy delete anything from the table.
e.g. delete table_name
this will remove the whole table from the database.
| Is This Answer Correct ? | 9 Yes | 28 No |
Post New Answer View All Answers
Explain an automatic checkpoint
What does this statement do @@rowcount?
Are there issues when exporting SSRS reports into Microsoft Excel? When my users are trying to export a SSRS report into Microsoft Excel, one or two columns in the report appear to merge together. Why might this be?
Can I run multiple instances of sql server 2000 at the same time on one computer?
Explain how does the report manager work in ssrs?
What is the difference between push and pull subscription? : sql server replication
What are types of storage modes? : sql server analysis services, ssas
Do you have any idea about the tcl commands?
Explain how to maintain a fill factor in existing indexes?
Different types of keys in SQL?
What should be the fill factor for indexes created on tables? : sql server database administration
What are the character string functions supported by sql server 2005?
what are different types of raid configurations? : Sql server database administration
What are the restrictions while creating batches in sql server?
What is replace and stuff function in sql server?
