我想把no 设PK, 还想把他设成索引。不好意思刚才看错了 还以为建成索引不要pk CREATE UNIQUE INDEX PK_B_ACCOUNTS ON tablename (NO) ALTER TABLE tablename ADD ( CONSTRAINT PK_B_ACCOUNTS PRIMARY KEY (NO) USING INDEX ;
CREATE UNIQUE INDEX PK_B_ACCOUNTS ON tablename (NO); ALTER TABLE tablename ADD ( CONSTRAINT PK_B_ACCOUNTS PRIMARY KEY (NO) USING INDEX ;
还以为建成索引不要pk
CREATE UNIQUE INDEX PK_B_ACCOUNTS ON tablename
(NO)
ALTER TABLE tablename ADD (
CONSTRAINT PK_B_ACCOUNTS
PRIMARY KEY
(NO)
USING INDEX ;
(NO);
ALTER TABLE tablename ADD (
CONSTRAINT PK_B_ACCOUNTS
PRIMARY KEY
(NO)
USING INDEX ;