Primary key

DB2 PrimaryKey 主键操作SQL总结

Categories: Database; Tagged with: DB2 • Primary key • SQL; @ October 5th, 2010 21:06

ALTER TABLE EMPLOYEE ADD PRIMARY KEY (EMPLOYEE_ID, ORGNO);

ALTER TABLE EMPLOYEE DROP PRIMARY KEY

ALTER TABLE TB2 ALTER COLUMN ID (DROP DEFAULT) SET GENERATED AS IDENTITY ( START WITH 0 INCREMENT BY 1 NO CACHE ) ;

DROP DEFATULT: 如果之前已有DEFAULT值时使用.

Categories: Database; Tagged with: DB2 • Primary key • SQL; @ October 3rd, 2010 15:01

ALTER TABLE TABLE2 DROP PRIMARY KEY

ALTER TABLE TABLE2 ADD ID2 INTEGER NOT NULL DEFAULT 1; ALTER TABLE TABLE2 ADD PRIMARY KEY(ID2);

Categories: Database; Tagged with: DB2 • JDBC • Primary key; @ October 3rd, 2010 14:50

SQL:

SELECT * FROM SYSIBM.SYSCOLUMNS WHERE TBCREATOR NOT LIKE ‘SYS%’ AND TBNAME = ‘TABLENAME‘ AND KEYSEQ > 0 ORDER BY KEYSEQ ASC;