What is the difference between Drop and Truncate
Answer Posted / pavan
Drop will delete all the existing structure. if it applies
to a table, Truncate will delete only the data while
keeping the structure of the table as it is.
| Is This Answer Correct ? | 72 Yes | 3 No |
Post New Answer View All Answers
IF more than one Site is accessing the same Database server and I want to move the DB with Minimum down time? How will you do
What is sub-query in sql server? Explain its properties.
What is the web service used for reporting services?
How to change the name of a database user?
How do you test your database? : sql server database administration
do you know how to configure db2 side of the application? : Sql server database administration
What is the xml datatype?
What is an active database?
Why I am getting "the microsoft .net framework 2.0 in not installed" message?
What is the difference between SQL notification and SQL invalidation?
What is snapshot report?
Explain primary key and foreign key constraints?
tell me what are the steps you will take to improve performance of a poor performing query? : Sql server database administration
Is oracle faster than sql server?
Is sql server free?