Progress
SQL-92
Guide and Reference


DROP SYNONYM Statement

Drops the specified synonym.

SYNTAX

DROP [ PUBLIC ] SYNONYM synonym ; 

PUBLIC

Specifies that the synonym was created with the PUBLIC argument.

SYNONYM synonym

Name for the synonym.

EXAMPLE

DROP SYNONYM customer ; 
DROP PUBLIC SYNONYM public_suppliers ; 

NOTES

AUTHORIZATION

Must have DBA privilege or ownership of the synonym (for DROP SYNONYM).

SQL COMPLIANCE

Progress Extension

ENVIRONMENT

Embedded SQL, interactive SQL, ODBC applications, JDBC applications

RELATED STATEMENTS

CREATE SYNONYM Statement


Copyright © 2004 Progress Software Corporation
www.progress.com
Voice: (781) 280-4000
Fax: (781) 280-4095