Difference Between Delete and Truncate | Delete vs Truncate | sql interview questions and answers

DELETE command removes the rows from a table based on the condition.TRUNCATE will actually remove all rows from the table and there will be no data in the table after we run the truncate command.

difference between truncate and delete in sql server,difference between delete and truncate and drop in sql server 2005,difference b/w delete and truncate,diff b/w truncate and delete,difference between delete and truncate in sql server with example,difference between delete and truncate in sql server 2012,difference between delete and truncate in sql server 2008,truncate table vs delete,difference between delete and truncate in sql server,difference between delete and truncate in oracle,difference between delete and truncate in sql server 2008,difference between delete and truncate in sql server with example,difference between delete and truncate in mysql

[agilan]

SQL (pronounced "ess-que-el") stands for Structured Query Language. SQL is used to communicate with a database. According to ANSI (American National Standards Institute), it is the standard language for relational database management systems.

[kalieswaran]

SQL is a database computer language designed for the retrieval and management of data in relational database. SQL stands for Structured Query Language.

[hemamalinig]

DROP and TRUNCATE are DDL commands, whereas DELETE is a DML command. Therefore DELETE operations can be rolled back (undone), while DROP and TRUNCATE operations cannot be rolled back.