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

DELETE FROM [ owner_name.] { table_name | view_name } 
  [ WHERE search_condition ] ; 

EXAMPLE

DELETE FROM customer WHERE customer_name = 'RALPH' ; 

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