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 the importance of a recovery model?
What is the use of sign function?
What are the acid properties?
Explain view in sql server?
How to create a local temporary stored procedure?
Difference between Inner vs outer joins?
What is difference between foreign key and unique key?
How to count rows with the count(*) function in ms sql server?
What is sub query and its properties?
How to recover from sql injection? : sql server security
What is subquery in sql?
What are the approximate numeric data types?
How is sql server used?
What is the difference between executequery () and executeupdate ()?
Tell me the use of keyword with encryption. Create a store procedure with encryption?