DELETE Statements

To delete information from a table, use DELETE statements.

​

DELETE Syntax

The DELETE statement requires the table name in the FROM clause and the row’s primary key in the WHERE clause, as shown in the following example:

<delete_statement> ::= DELETE FROM <table_name> WHERE { Id = <expression> } [ { AND | OR } ... ]
 
<expression> ::=
  | @ <parameter>
  | ?
  | <literal>

The following is an example query:

DELETE FROM Orders WHERE Id = @myId