Home

	Expand Search

Access Service User's Guide DirectConnect for AS/400

Chapter 7 Using Sybase mode commands

delete (dynamic command)

delete (dynamic command)

Description

Using a dynamic command, delete removes a row from a table.

Syntax

delete [[database.]owner.]{table_name | view_name} 
 [where search_conditions]

Any valid object in the catalog can be substituted for table_name or view_name.

Parameters

is a standard where clause.

is a valid where clause component. It sets the conditions for the rows that are retrieved. A search condition can include column names, constants, joins, the keywords is null, is not null, or, like, and, or any combination of these items.

Examples

Example 1

  delete from tablea 
 where col1 = "test"

Usage

• Following are relational operators that are supported in search conditions: =, <>, <, >, <=, >=, and like.

• The prepared statement can execute multiple times before it is deallocated.