CREATE TABLE table_name20160926163735635(
miji VARCHAR2(100) NOT NULL UNIQUE,
bumen VARCHAR2(100) NOT NULL UNIQUE,
dfsdf VARCHAR2(100) NOT NULL UNIQUE,
dfsdfsgs VARCHAR2(100) NOT NULL UNIQUE);
COMMENT ON table table_name20160926163735635 IS '文件w';
COMMENT ON COLUMN table_name20160926163735635.miji IS '密级';
COMMENT ON COLUMN table_name20160926163735635.bumen IS '部门';
COMMENT ON COLUMN table_name20160926163735635.dfsdf IS 'dsfsg';
COMMENT ON COLUMN table_name20160926163735635.dfsdfsgs IS 'dsfsgsgs';
ALTER TABLE table_name20160926163735635 ADD PRIMARY KEY(dfsdf);
设置主键发生错误:
dfsdf 为unique,去掉unique 则可以设置为主键;
能够与另一个字段组合为联合主键,此时联合主键中的字段可以设置为unique。
CREATE INDEX fhd ON table_name20160926172046881(miji);
报错:
跟unique有关;去掉unique可以创建索引