Answer Posted / v.krishnakumar
in truncate we can delete inside the table data not the
structure of the table,in delete operation we can remove
our data in the table as well as structure but we can get
again using rollback operation, in drop operation it was
permanentely removed from our database we cannot get agian.
| Is This Answer Correct ? | 13 Yes | 2 No |
Post New Answer View All Answers
What is etl - extraction, transformation, and loading?
Explain cursor as data base object?
Tell me about the approaches which you used to counter the DI problems.
How to make a remote connection in a database?
How dts is used to extract, transform and consolidate data?
How to view the error log for any specific instance? : sql server database administration
Explain hostprotectionattribute in sql server 2005?
What is join query?
Explain tablesample?
How to create a simple table to test triggers in ms sql server?
Can we call stored procedure in trigger?
Do you know what is rank function?
What are the essential components of sql server service broker?
What is sql injection and why is it a problem? : sql server security
Does partitioning ssd reduce performance?