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 sql server english query?
What is a print index?
Do you think BCNF is better than 2NF & 3NF? Why?
What are different types of raid configurations? : SQL Server Architecture
What are the differences between lost updates and uncommitted dependencies?
What is the stuff?
Write a sql query to get zero records from a table having n number of records?
What are click through reports?
Explain nested trigger in sql?
how would you troubleshoot blocking? : Sql server database administration
Stored Procedure returns data from multiple tables. How to access it in your ASP.Net code?
What is buffer cash in sql server?
How do I find the size of a sql server database?
What is the optimization being performed in oracle and SQL Server?
What is rolap and its advantage? : sql server analysis services, ssas