SQL Training Course: Data Definition Language, DROP ALIAS or SYNONYM

June 22nd, 2009

Posted by admin in Q. Data Definition Language

Format:

          DROP ALIAS alias_name;

          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.

Subscribe to comments with RSS or TrackBack to ' Data Definition Language, DROP ALIAS or SYNONYM '.

Katy said,

on June 23rd, 2009 at 8:36 pm

Pretty nice post. I just stumbled upon your blog and wanted to say
that I’ve really enjoyed reading your blog posts. In any case
I’ll be subscribing to your blog and I hope you post again soon!
KonstantinMiller said,

on July 6th, 2009 at 1:47 pm

Hello, can you please post some more information on this topic? I would like to read more.
Bill Bartmann-_ said,

on September 10th, 2009 at 2:44 am

This site rocks!
bad credit loans said,

on December 29th, 2009 at 11:56 pm

Good Afternoon!!! http://www.computerbasedtraininginc.com is one of the best informational websites of its kind. I take advantage of reading it every day. http://www.computerbasedtraininginc.com rocks!
payday loans said,

on January 23rd, 2010 at 4:57 pm

The author of http://www.computerbasedtraininginc.com has written an excellent article. You have made your point and there is not much to argue about. It is like the following universal truth that you can not argue with: Money cannot buy happiness, but it can at least pay for some new components. Thanks for the info.