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



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

View Questions and Answers by Category

Advertisements


 
Have Programming Question? Ask it here!
 
 
 


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