Progress
SQL-92
Guide and Reference
DELETE Statement
Deletes zero, one, or more rows from the specified table that satisfy the search condition specified in the WHERE clause. If the optional WHERE clause is not specified, then the DELETE statement deletes all rows of the specified table.
SYNTAX
EXAMPLE
NOTE
AUTHORIZATION
Must have DBA privilege, ownership of the table, of DELETE permission of the table.
SQL COMPLIANCE
SQL-92, ODBC Extended SQL grammar
ENVIRONMENT
Embedded SQL, interactive SQL, ODBC applications, JDBC applications
RELATED STATEMENTS
"Search Conditions" in "SQL-92 Language Elements", WHERE Clause
Copyright © 2004 Progress Software Corporation www.progress.com Voice: (781) 280-4000 Fax: (781) 280-4095 |