What's the difference between DELETE TABLE and TRUNCATE
TABLE commands?
Answer Posted / baijnath tiwari
TRUNCATE is a DDL command whereas DELETE is a DML command.
Hence DELETE operation can be rolled back, but TRUNCATE
operation cannot be rolled back. WHERE clause can be used
with DELETE and not with TRUNCATE.
Is This Answer Correct ? | 1 Yes | 2 No |
Post New Answer View All Answers
What is multilevel indexing?
mention different types of relationships in the dbms?
What is the use of floor function in sql server?
How to create prepared statements using odbc_prepare()?
What is the difference between DataRow.Delete() and DataRow.Remove()?
Can group functions be mixed with non-group selection fields in ms sql server?
How can delete duplicate records in cte in sql server?
What is sql server management studio? : sql server management studio
How to truncate the log in sql server 2012? : sql server database administration
What is a unique key constraint?
how many type of indexing in database?
Can I use sql azure as a backup with log shipping or database mirroring?
When would you use an insert into .. Select option versus an insert into .. Values option? Give an example of each?
Please explain the characteristics of a transaction server for example atomicity, consistency, isolation, durability?
What is sql server agent and what are the two modes of authentication in sql server?