Re: Create Table

Another Testing, this time I remove the single extraneous comman at the end of the first line,

create table bb ( cc int, b int
constraint cc primary key (cc)
)

MSSQL:OK
Oracle:Fail
Sybase:Fail

On Wed, 8 Jul 1998, Don Macpherson wrote:

> Johnnie,
> Presumably 2> fails on Oracle due to the single extraneous comma at
> the end of the first line.
> According to the SQL92 standard (Entry, Intermediate or Full), this
> should fail.
>
> Don Macpherson
>
> Johnnie Isg wrote in message ...
> >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
>
>
>
>
Received on Thu Jul 09 1998 - 00:00:00 CDT