SQL Operations: Deleting a Record

To delete a record in SQL, you can use the DELETE operator.

To delete all records from a table, type DELETE followed by the name of the table, using this formula:

DELETE TableName;

Here is an example:

DELETE FROM Employees;

To delete a record, use this formula:

DELETE FROM TableName
WHERE Condition(s)

Here is an example:

DELETE FROM Employees
WHERE EmployeeNumber = 24685;

 

Home	Copyright © 2009-2011 FunctionX.com