Latest Tutorials| Questions and Answers|Ask Questions?|Site Map



Home Answers Viewqa SQL What is the Delete Statements in SQL?

Have Programming Question? Ask it here!
 
 
 


hemant kumar
What is the Delete Statements in SQL?
1 Answer(s)      3 years and 5 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,



Related Tutorials/Questions & Answers:
Advertisements
Advertisements
 

 

 

DMCA.com