Re: Is there a SQL92 compliant CREATE TABLE statement?

Try this link:

http://www.idera.com/support/documentation/SQL92__SQL_2__Syntax_Reference.htm

Qingqing

jsander_at_puc-online.de (Johann Sander) wrote in message news:<ff2b8f88.0201170319.47622aec_at_posting.google.com>...
> Hello,
>
> 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?).
>
> In most situations, DB2 will create the table without any trouble in
> the USERSPACE1 tablespace. But as soon as the dba creates a new user
> tablespace and then removes the default tablespace, which is
> USERSPACE1, applications will no longer be able to use the test
> statement from above. Instead, they will have to use:
>
> CREATE TABLE TEST( COL1 INTEGER) IN TS_NEW (or whatever that new
> tablespace's name will be)
>
> Thanks for your time
Received on Thu Jan 17 2002 - 21:39:43 CET