Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Create Table

Create Table

From: Johnnie Isg <johnnie_at_prima.netfront.net>
Date: 1998/07/08
Message-ID: <Pine.BSI.3.96.980708154427.9571A-100000@prima.netfront.net>#1/1

I am testing two create table statements in different databases. I want to know if they are SQL92 or SQL3 Standard Compliance statements

1>
create table a ( a int, b int ,
constraint a primary key (a)
)

2>
create table a ( a int, b int ,
--constraint a primary key (a)
)

Results:

Oracle:
1>OK
2>Fail

MSSQL:
1>Fail
2>OK

Sybase:
1>OK
2>OK Received on Wed Jul 08 1998 - 00:00:00 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US