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 Rdbms?
What is the default fill factor value?
How to reaname table name without using sp_Rename in sql server..?
What is difference between drop truncate and delete?
How many null values we can have in a unique key field in sql server?
What is the process of normalising?
 Explain what is sql override for a source taLle in a mapping?
What is table valued function and scalar valued functions?
Why use “nolock” in sql server?
Why I have to use stored procedures?
Difference between report and query parameter.
How to get a list of columns in a view using the "sp_help" stored procedure?
What is the command to change the recovery model?
How you can get a list of all the table constraints in a database? : Sql server administration
Can I disable or restrict ssrs export formats (rendering formats)?
