Delete Data

delete works for both single-row and multiple-row operations.

The where clause specifies which rows are to be removed. When no where clause is given in the delete statement, all rows in the table are removed. See the Reference Manual: Commands.

• Use the from Clause with delete
  The from clause in the second position of a delete statement allows you to select data from one or more tables and delete corresponding data from the first-named table.
• Delete from IDENTITY Columns
  You can use the syb_identity keyword in a delete statement on tables containing an IDENTITY column.