SQL Delete Query


SQL DELETE Statement


IN SQL DELETE Query  is used to delete existing records in a table



DELETE Syntax -The Basic Syntax For DELETE table are as Follows

DELETE syntax for delete the specified record from the table

SQL>DELETE FROM table_name WHERE condition;



DELETE Synatx for record all the Column From the table

SQL>DELETE FROM table_name;



Delete A specify Record-

Example

SQL>DELETE FROM Student  WHERE StudentName='Ram;

In above Query it will Delete the student whose name is ram from the Student table .



Delete All Records

Example

SQL>DELETE FROM Customers;

In above Query it will Delete all the Row Present in Student table .it Will Not  delete the table just Delete all the Column.

Post a Comment

0 Comments