What standard defines the "IF EXISTS" clause of the DROP TABLE or
CREATE TABLE syntax?

Sorry if this if off topic, asked out of curiosity as to why it is not
widely available in various SQL variants.

cj

On Thu, 10 Jan 2008 06:10:17 -0800 (PST), CJ
<spambox1 (AT) mindspring (DOT) com> wrote:

The SQL92 and SQL99 standards don't define it.

HTH
--
( Kees
)
c[_] I distinctly remember forgetting that. (#155)

On Thu, 10 Jan 2008 06:10:17 -0800 (PST), CJ
<spambox1 (AT) mindspring (DOT) com> wrote:

Also not in SQL2003
http://savage.net.au/SQL/
--
( Kees
)
c[_] I distinctly remember forgetting that. (#155)

On Jan 10, 10:05 am, Kees Nuyt <k.n... (AT) nospam (DOT) demon.nl> wrote:
Thanks to all, but I am looking to find out if any standard defines
this SQL syntax, or if this is simply a construct of mysql. I can
find no standard defining such syntax, which begs the question "why?"

It seems a very straight forward and useful syntax to have been simply
overlooked by ANSI. Was it expressly excluded by ANSI?

cj

CJ wrote:

I believe you are confusing ANSI standard with Oracle Standard. At the
time Oracle introduced MANY syntactical changes they were not a part of
of the ANSI standard. To answer your "why" ??... because each db
product can do what ever they like when defining the syntax to be used
on their platform - They can be
< ANSI standard ! MYSQL, ???
ONLY ANSI standard ! don't know any off hand...
ANSI standard + ! Oracle, DB2, Rdb, Sybase to name a few.

MYSQL is < ANSI standard due the way some of their data types do not
return data properly. [Search the bug database for CHAR.]