hemant kumar
What is the Delete Statements in SQL?
1 Answer(s)      4 years and 7 months ago
Posted in : SQL

What is the Delete Statements in SQL?

Advertisement
View Answers

November 19, 2010 at 3:58 PM


Hi,

Here is the answer,

Delete statement in SQL is used to delete partial/all data. Especially delete statement is useful in case of partial delete depending upon our criterias otherwise use TRUNCATE to

delete whole data from table.

DELETE FROM table_name WHERE column_name = some_value

Delete All Rows:

DELETE FROM table_name or DELETE * FROM table_name

Thanks,