Using a dynamic command, delete removes a row from a table.
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.
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.
delete from tablea where col1 = ”test”
Following are relational operators that are supported in search conditions: =, <>, <, >, <=, >=, and LIKE.
The prepared statement can execute multiple times before it is deallocated.
| Copyright © 2005. Sybase Inc. All rights reserved. |
|
|
