June 22nd, 2009

Data Definition Language, DROP ALIAS or SYNONYM

Posted by admin in Q. Data Definition Language

Format:

          DROP ALIAS alias_name;

                                     or

          DROP SYNONYM synonym_name;

This command will remove the alias or synonym.
Example:

          DROP SYNONYM PILOTS;

> Aliases and synonyms are not an SQL standard.

> DB2, Informix, and Oracle implement ALIAS and SYNONYM.

> MySQL does not implement ALIAS or SYNONYM.

Comments are closed.

Sorry, the comment form is closed at this time.