Re: Create Table

It looks like the constraint name cannot use table object name but can be same as coulmn name since the following statement works fine.

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

On Wed, 8 Jul 1998, Tony Rogerson wrote:

> 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.
>
>
>
>
>
Received on Thu Jul 09 1998 - 00:00:00 CDT