Interested to Buy Any Domain ? << Click Here >> for more details...
What's the difference between DELETE TABLE and TRUNCATE
TABLE commands?
- 9 Answers
- 19091 Views
- I also Faced
- E-Mail Answers
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 the fillfactor concept in indexes?
What are the new features introduced in SQL Server 2000 (or the latest release of SQL Server at the time of your interview)? What changed between the previous version of SQL Server and the current version?
What are statistics?
What is a result set object returned by odbc_exec()?
what is the difference between them (ethernet networks and token ring networks)? : Sql server database administration
Does partitioning improve performance?
What are the triggers in sql?
what is the Ticketing tool used in Wipro technologies at Bangalore...???
What is the main purpose of having conversation group?
What is sql view?
What is schemabinding a view?
Are null values the same as that of zero or a blank space?
Can we add an identity column to decimal datatype?
What is the difference between migration and upgradation in sql server?
Explain what are the database objects? : SQL Server Architecture
