What is the difference between Drop and Truncate
Answer Posted / madhu
drop will delete the entier table content including its
structure.
but truncate will delete the datas which in the table.
it wont save the data any where so we cannot rollback those
data.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
How to convert numeric values to integers in ms sql server?
What is the name of the system variable that returns the number of rows affected by a SQL statement?
what is raid and what are different types of raid configurations? : Sql server database administration
What is page in sql server?
what is bit datatype? : Sql server database administration
What are the benefits of filtered indexes?
What are the advantages of stored procedure in sql server?
Can you insert NULL in unique column?
what is the different types of backups available in sql server? : Sql server database administration
What function does a database engine serve in the sql server?
What is an index in sql?
How to use old values to define new values in update statements in ms sql server?
What is implicit cursors?
How will you go about resolving deadlocks?
What's new in sql management studio for sql server? : sql server management studio