DB2 PrimaryKey 主键操作SQL总结

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

1. ADD PRIMARY KEY 增加主键

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

2. DROP PRIMARY KEY 删除主键

ALTER TABLE EMPLOYEE DROP PRIMARY KEY

3. SET AUTOINCREMENT 设置自增

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

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

DB2 Index 索引操作SQL <-> DB2 Alter 增加自增列 Add AutoIncrement Column

---

ActionScript Adobe AIR ANT Apache ApacheFlex Apache Flex Better Developer BlazeDS Cloud Computing CMD DataGrid DataGridColumn DB2 Derby DTSX Eclipse ETL Event Excel Flash Builder Flex Google Java JDBC JDK JIRA Life@SG|新加坡 Linux MySQL Oracle PHP Python RegEx Servlet SQL SQL Server SSIS SVN T-SQL Tools Tree Ugly WordPress XML dev-notes side-projects