Interested to Buy Any Domain ? << Click Here >> for more details...
What's the difference between DELETE TABLE and TRUNCATE
TABLE commands?
- 9 Answers
- 18702 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
Are connections to sql server encrypted?
What are the types of processing and explain each? : sql server analysis services, ssas
List the different types of joins?
You want to use bids to deploy a report to a different server than the one you chose in the report wizard. How can you change the server url?
What is the report model project?
Do you know the cursor types?
How do I manually uninstall an instance of sql server 2016?
What is difference between table aliases and column aliases? Do they affect performance?
What is store procedure?
What is sql stored procedure?
How raid can influence database performance?
What is isolation levels?
What are translations and its use? : sql server analysis services, ssas
What are advantages of ssrs or why we should use ssrs?
What is a view in sql?
