Hi there,

I have the following script:


CREATE TABLE "AADDRESS" (
"CUSTOMER_ID" VARCHAR(10) CHARACTER SET ISO8859_1 NOT NULL ,
"COUNTER" CHAR(5) CHARACTER SET ISO8859_1 NOT NULL PRIMARY KEY ,
"ADDRESS_ID" VARCHAR(15) CHARACTER SET ISO8859_1 NOT NULL ,
"ADDRESS_LINE1" VARCHAR(40) CHARACTER SET ISO8859_1 ,
"ADDRESS_LINE2" VARCHAR(40) CHARACTER SET ISO8859_1 ,
"ADDRESS_LINE3" VARCHAR(40) CHARACTER SET ISO8859_1 ,
"ADDRESS_LINE4" VARCHAR(40) CHARACTER SET ISO8859_1 ,
"ADDRESS_LINE5" VARCHAR(40) CHARACTER SET ISO8859_1 ,
"APPROVEDBY" VARCHAR(10) CHARACTER SET ISO8859_1 ,
"LOCKED" INTEGER NOT NULL ,
"ROLLEDOVER" INTEGER NOT NULL
)

Instead of having PRIMARYKEY as the Index Key Name , how should to change the script to change the default name of the Primary Key?

Thanks.

Kelvin Chua
SINGAPORE


[Non-text portions of this message have been removed]