遇到这样一组语句 建表 建索引 建主键 ,在建立主键的时候提示SQL0598W
虽然PK是建立上了,但是,如何才能不让这个信息出现呢
建表:
CREATE TABLE SVR_INFO (
"SVR_ID " INTEGER NOT NULL ,
"SVR_IP " VARCHAR(15) NOT NULL ,
"SVR_NAME " VARCHAR(40) NOT NULL ,
"PORT_NO " INTEGER NOT NULL ,
"USER_NAME " VARCHAR(15) NOT NULL ,
"PWD " VARCHAR(32) NOT NULL ,
"REMARK " VARCHAR(20) )
IN "USERSPACE1 " INDEX IN "USERSPACE1 " ;
建索引:
CREATE UNIQUE INDEX SVR_INDEX1 ON SVR_INFO
( "SVR_ID " ASC)
INCLUDE ( "PWD " ASC,
"USER_NAME " ASC,
"PORT_NO " ASC,
"SVR_IP " ASC) ALLOW REVERSE SCANS;
建主键:
ALTER TABLE SVR_INFO
ADD PRIMARY KEY
( "SVR_ID ");
------解决方案--------------------------------------------------------
CREATE TABLE SVR_INFO ( "SVR_ID" INTEGER NOT NULL , "SVR_IP" VARCHAR(15) NOT NULL , "SVR_NAME" VARCHAR(40) NOT NULL , "PORT_NO" INTEGER NOT NULL , "USER_NAME" VARCHAR(15) NOT NULL , "PWD" VARCHAR(32) NOT NULL , "REMARK" VARCHAR(20),PRIMARY KEY (SVR_ID) ) ;
将建立主键放到CREATE TABLE 的命令里面.