Re: SQL Alter table: can I remove the UNIQUE attribute from a key?

You mean like this:
UNIQUE
R ABR
MYKEY 11A
MYDATA 10A
K MYKEY

INSERT INTO ROB/AB VALUES(1, 1)
1 rows inserted in AB in ROB.
INSERT INTO ROB/AB VALUES(1, 1)
Duplicate key value specified.

ALTER TABLE ROB/AB DROP PRIMARY KEY RESTRICT
Table AB in ROB does not have a primary or unique key.

ALTER TABLE ROB/AB ADD PRIMARY KEY (MYKEY)
ALTER completed for table AB in ROB.

ALTER TABLE ROB/AB DROP PRIMARY KEY RESTRICT
ALTER completed for table AB in ROB.

INSERT INTO ROB/AB VALUES(1, 1)
1 rows inserted in AB in ROB.

Summary: Yes. Even though it already has a primary key ADD the
constraint with SQL and then delete the constraint with SQL and it drops
the primary key.


Rob Berendt