Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Create Table
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
![]() |
![]() |