How to create a Delete query (Enterprise Manager)

To create a Delete query

1. Add the table to delete rows from to the Diagram pane.
2. Start a Delete query by right-clicking in the Diagram or SQL pane, choosing Change Type, and then choosing Delete.

   ---

   Note If more than one table is displayed in the Diagram pane when you start the Delete query, the Query Designer displays the Delete Table dialog box to prompt you for the name of the table to delete rows from.

   ---

3. Enter search conditions to define the rows to be deleted. For details, see Specifying Search Conditions. If you do not specify a search condition, all rows in the specified table will be deleted.

   ---

   Note Because you cannot delete the contents of individual columns, the check boxes in the input source window are removed when you start a Delete query. To add columns to the Grid pane to use in search conditions, drag them from the input source window to the Columns column, or select a data column in the Columns column.

   ---

   When you execute the Delete query, no results are reported in the Results pane. Instead, a message appears indicating how many rows were deleted.