Alter Table

[JimReiley]

I'm using the statement below to create the primary key on a table. The key needs to be non modifiable. I can't see anyway to include that restriction with this statement. Would it be more appropriate to use a create unique index statement instead?

ALTER TABLE adspxapi in Dictionary ADD PRIMARY KEY (AdNumber,EntryYear,PubNumber) #


Jim R

 

[mirtheil]

Looking at the docs, I would suggest issuing the CREATE INDEX with the "Not Modifiable" keyword and then the ALTER TABLE to set it as a primary key. Here's the example from the docs:

CREATE TABLE t1 (c1 INT NOT NULL, c2 CHAR(10) NOT NULL)
CREATE UNIQUE INDEX t1_c1c2 ON t1(c1,c2)
ALTER TABLE t1 ADD PRIMARY KEY(c1, c2)

Also:
Before adding the primary key, you must ensure that the columns in the primary key column list are defined as NOT NULL. A primary key is a unique index and can be created only on not nullable columns.

Mirtheil
Certified Pervasive Developer
Certified Pervasive Technician

http://www.mirtheil.com