HOW TO DROP, TRUNCATE AND DELETE TABLE?

Question

272 viewsJune 14, 2023SQLSQL

0

Saraswat World 417 June 14, 2023 0 Comments

Write your answer.

score 0 · Answer 1 · 2023-06-14T07:46:56+00:00

Key Word	Syntax	Explanation
DROP TABLE	DROP TABLE <table_name>;	DROP TABLE is used to delete a table definition and all data from a table
TRUNCATE TABLE	TRUNCATE TABLE <table_name>;	TRUNCATE TABELE is used to remove all rows or complete data from a table. It doesn’t delete the structure of table. Identity column is reset to its seed value if the table contains any identity column
DELETE	DELETE FROM <table_name>;	It will delete all the records in table. DELETE retains the identity of the column value.
DELETE	DELETE FROM <table_name> WHERE<condition/expression>;	Remove rows or specific records from a table based on a WHERE condition.

DROP TABLE, TRUNCATE TABLE AND DELETE

Comments