Athena Framework
Tag Archives: SQL
Oracle: 扩充TableSpace语句
Step1: check current status and get all file path
SELECT
B.FILE_NAME FILENAME,
B.TABLESPACE_NAME TABLESPACENAME,
B.BYTES/1024/1024 SIZE_MB,
(B.BYTES-S
DB2 V9.7 Rename Column注意事项
DB2需要呼叫存储过程ALTOBJ存储过程以完成重命名. 该过程将重建Table, 并恢复就有的PrimaryKey, Index信息及Table的内容.
在Rename带有Index的Column时需要额外注意, 可能先DROP掉Index, 在重建完毕后再CREATE.
DB2 Alter 增加自增列 Add AutoIncrement Column
ALTER TABLE TABLE2 ALTER COLUMN ID2 DROP DEFAULT SET GENERATED AS IDENTITY ( START WITH 0 INCREMENT BY 1 NO CACHE ) ;
DB2 PrimaryKey 主键操作SQL总结
1. ADD PRIMARY KEY 增加主键
ALTER TABLE EMPLOYEE ADD PRIMARY KEY (EMPLOYEE_ID, ORGNO);
2. DROP PRIMARY KEY 删除主键
ALTER TABLE EMPLOYEE DROP PRIMARY KEY
3. S
