Interested to Buy Any Domain ? << Click Here >> for more details...
What's the difference between DELETE TABLE and TRUNCATE
TABLE commands?
- 9 Answers
- 18701 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 to execute stored procedure in select statement sql server?
How to insert a new row into a table with "insert into" statements in ms sql server?
What is indexing explain it with an example?
What are actions, how many types of actions are there, explain with example? : sql server analysis services, ssas
What do you understand by user-defined function in the sql server and explain the steps to create and execute a user-defined function in the sql server?
Write a sql query to display the current date?
Explain what is raid and what are different types of raid levels?
what are the important architecture components of SSRS?
Are there any preferred steps that need to be taken care of before starting the installation of sql server 2000?
What do you mean by recursive stored procedure?
What is blocking?
How do I get to sql server configuration manager?
Can group functions be mixed with non-group selection fields in ms sql server?
How to list all field names in the result set using mssql_field_name()?
Mention the different types of triggers?
