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


Please Help Members By Posting Answers For Below Questions

Tell me about normalization in DBMS.

785


What are the steps to insert a table?

734


How to drop an existing user defined function in ms sql server?

822


Why truncate is ddl?

858


What happens if null values are involved in bitwise operations?

832


Explain what are the restrictions that views have to follow? : SQL Server Architecture

842


What action plan is preferred if sql server is not responding?

818


How to override dml statements with triggers?

785


What to check if a User database is locked?

826


What does truncate do?

731


What are the basic functions for master, msdb, model, tempdb and resource databases? : SQL Server Architecture

777


How to use go command in "sqlcmd"?

910


Explain hostprotectionattribute in sql server 2005?

825


What is sql server locking?

748


Why use “in” clause in sql server?

779