Interested to Buy Any Domain ? << Click Here >> for more details...
What's the difference between DELETE TABLE and TRUNCATE
TABLE commands?
- 9 Answers
- 19089 Views
- I also Faced
- E-Mail Answers
Answer Posted / radh
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 ? | 27 Yes | 1 No |
Post New Answer View All Answers
How to get the definition of a stored procedure back?
How to verify a user name with sqlcmd tool?
What is the difference between push and pull subscription? : sql server replication
what is a schema in sql server 2005? Explain how to create a new schema in a database? : Sql server database administration
if you encounter this kind of an error message, what you need to look into to solve this problem? : Sql server database administration
What command do we use to rename a database?
How to bind a view to the schema of the underlying tables?
What sql server means?
What is database dimension? : sql server analysis services, ssas
Can we linked SharePoint to a SQL database?
What are system databases in ms sql server?
What are rest-style architecture's?
What are the different types of sub-queries?
How would you use user_constraints table in DB?
Define indexes?
