delete sql
snippet in sql

delete sql

user913


 DELETE FROM table_name WHERE condition;
 

query to empty table data in sql server

user6842

TRUNCATE TABLE  table_name;

sql delete row

user5170


 DELETE FROM Customers
 WHERE CustomerName='Alfreds Futterkiste';
 

sql delete

user3206

DELETE FROM my_table;		-- all rows
DELETE FROM my_table WHERE my_id = 12345;
DELETE FROM my_table WHERE my_id IN (SELECT id2 FROM my_table2);
COMMIT;		-- don't forget it...

delete a table in sql

user6686


  DROP TABLE table_name; 

drop all data from tables

user9787

DELETE FROM table_name WHERE condition;