Re: What's wrong with this SQL?

[snip]
>>>>>I greatly dislike in-line constraint creation which is what you are
>>>>>doing and would suggest you just build the table and then use ALTER
>>>>>TABLE to create your primary key and other constraints. There is no
>>>>>need to be building an index that already exists.
[snip]

Do as Daniel says.

What they do make little sense. Toss the inline primary key and the create index. Instead do...

ALTER TABLE ss_sessionspec5
add CONSTRAINT XIE1ss_sessionspec5 PRIMARY KEY (sessionid);

/Bent Received on Fri Jan 14 2005 - 03:54:01 CST