Can you tell me the difference between DELETE & TRUNCATE
commands?
Answer Posted / kumar
Truncate will fail if the concerned table has foreign key
constraints while delete doesnt.
Is This Answer Correct ? | 15 Yes | 10 No |
Post New Answer View All Answers
Tell me about normalization in DBMS.
What are the steps to insert a table?
How to drop an existing user defined function in ms sql server?
Why truncate is ddl?
What happens if null values are involved in bitwise operations?
Explain what are the restrictions that views have to follow? : SQL Server Architecture
What action plan is preferred if sql server is not responding?
How to override dml statements with triggers?
What to check if a User database is locked?
What does truncate do?
What are the basic functions for master, msdb, model, tempdb and resource databases? : SQL Server Architecture
How to use go command in "sqlcmd"?
Explain hostprotectionattribute in sql server 2005?
What is sql server locking?
Why use “in” clause in sql server?