Oracle事例
1.增加主键
altertableTABLE_NAMEaddconstraintKEY_NAMEprimarykey(TABLE_COLUMN);
指定表空间
altertableTABLE_NAMEaddconstraintKEY_NAMEprimarykey(TABLE_COLUMN)usingindextablespaceTABLE_SPACE_NAME;
2.增加外键
altertableTABLE_NAMEaddconstraintFK_NAMEforeignkey(TABLE_COLUMN)referencesK
下载地址
用户评论