Answer Posted / aman sharma
truncate are the use to the remove the data as well all the space into the table , and the delete are use to the delete only for the data into the table,and the drop is use to the delete or remove the table....
| Is This Answer Correct ? | 5 Yes | 1 No |
Post New Answer View All Answers
What is a non clustered primary key?
What is a field in a table?
How to insert a new row into a table with "insert into" statements in ms sql server?
What is a result set object returned by mssql_query()?
What is a mixed extent?
Does a server store data?
What is the security principal at the database level that represents your session?
What is 'write-ahead log' in sql server 2000 ?
What is the largest component inside a field?
Explain what is it unwise to create wide clustered index keys?
What is the difference between cube operator and rollup operator? : SQL Server Architecture
What is the most common trace flags used with sql server?
How do I completely remove sql server instance?
Why would you use sql agent?
What is table constraint?
