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 are the 7 disadvantages to a manual system?
What is the stored procedure?
Help!!!!!!!!!!!! My database has gone offline, it is highlighted as 'Suspect'. Foolishly, i haven't got a recent back up. Is there a way of quickly restoring the database? Thank you
Can sql server be linked with other servers like oracle?
what are user defined datatypes and when you should go for them? : Sql server database administration
How to set the current database in ms sql server?
Detail about query optimizer?
Explain subquery and state its properties?
Can you explain what are various ways to enhance the ssrs report?
How to throw custom exception in Stored Procedure?
What are the benefits and tasks of object explorer? : sql server management studio
Can sql servers link to other servers like oracle?
Find nth lowest salary or get nth lowest salary?
How many databases can we create in a single server?
How to delete all rows with truncate table statement in ms sql server?