Interested to Buy Any Domain ? << Click Here >> for more details...
What's the difference between DELETE TABLE and TRUNCATE
TABLE commands?
- 9 Answers
- 19344 Views
- I also Faced
- E-Mail Answers
Answer Posted / sreedhar
Truncate is DDL command, Delete is a DML command.
Delete operation can be rolled back and in truncate we
can't.
Where caluse can be used in Delete and not in Truncate.
Truncate table less time than delete in execution
| Is This Answer Correct ? | 5 Yes | 2 No |
Post New Answer View All Answers
How many non clustered indexes there can be on table ?
How to see the event list of an existing trigger using sys.trigger_events?
How do I find the sql server instance name?
What is impersonation? What are the different impersonation options available in ssas? : sql server analysis services, ssas
Are semicolons required at the end of sql statements in sql server 2005?
can an order by clause be used in a creation of a view?
Tell about MOM Tool(Microsoft Operator Manager)?
What is the largest component inside a field?
What is a covered index?
plss anybody specify tha constrian management system in dbms
what is a transaction and what are acid properties? : Sql server database administration
What is full outer join in sql server joins?
What is a schema in ms sql server 2005?
What is the cartesian product of table?
You have several tables, and they are joined together for querying. The tables contain both clustered indexes and non clustered indexes to optimize performance, how should you distribute the tables and their indexes onto different file groups?
