Re: Create Table

Not sure of the compliance, but the reason the MSSQL (1) fails is that you cant have a primary key constraint name the same name as another object in the database.

create table a ( a int, b int ,
constraint pk_a primary key (a)
)

would work.

--
Hope the above helps,

Tony Rogerson
Torver Computer Consultants Ltd.