ALTER TABLE

[Steve Huff]

The following SQL works for me:

ALTER TABLE TEMP_TBLENTRY ALTER COLUMN IIN TEXT(50) PRIMARY KEY;

However - I need to set the name of the PrimaryKey index so I know how to
reference it in code and using the above statment sets it to some text that
appears to be random. I tried:

ALTER TABLE TEMP_TBLENTRY ALTER COLUMN IIN TEXT(50) PRIMARY KEY (PK);

and a few varients but nothing worked. Can someone point me in the right
direction? Thanks!!

-Steve Huff

 

[Van T. Dinh]

Try :

****Untested SQL****
ALTER TABLE TEMP_TBLENTRY
ALTER COLUMN IIN TEXT(50)
CONSTRAINT PK_TEMP_TBLENTRY PRIMARY KEY;



PK_TEMP_TBLENTRY should be the the name of the Index.

 

[Steve Huff]

Thanks, worked great!