Re: Is there a SQL92 compliant CREATE TABLE statement?

From: Fan Ruo Xin <fanruox_at_yahoo.com>
Date: Fri, 18 Jan 2002 00:32:38 GMT
Message-ID: <3C476D51.60D0D0D@yahoo.com>

--CELKO-- wrote:

> >> can anybody please pass the syntax of an SQL92 compliant CREATE
> TABLE
> statement (if there is one)?
>
> I want to check if DB2 UDB is conforming to standards. Take this
> statement for example:
>
> CREATE TABLE TEST( COL1 INTEGER)
>
> I believe this simple statement to be SQL92 compliant (is it?). <<
>
> It is. But Standard SQL does not say anything about tablespace or
> other things at that PHYSICAL level. Oracle, SQL Ser ver, etc. will
> all be a little different in the systems environment.

Yes, actually, even the definition of tablespace for IBM DB2 UDB and ORACLE is different. Thanks, Received on Thu Jan 17 2002 - 18:32:38 CST