ORACLE
--修改表结构
ALTER TABLE table_name RENAME TO table_name2 --修改表名
ALTER TABLE table_name RENAME COLUMN column_name TO column_name2 --修改表列名
ALTER TABLE table_name MODIFY column_name NUMBER(20) --修改字段类型
ALTER TABLE table_name MODIFY ("column_name" NOT NULL ENABLE); --修改字段类型
ALTER TABLE table_name ADD column_name VARCHAR2(40) --添加表列
ALTER TABLE table_name DROP column_name CASCADECONSTRAINTS --删除表列
--添加comment
COMMENT ON COLUMN "table_name"."column_name" IS 'hello';
--oracle没有boolean类型所以用NUMBER(1,0)代替
"WARNING" NUMBER(1,0) DEFAULT 0
--新建sequence
CREATE SEQUENCE "sequence_name" MINVALUE 0 MAXVALUE 9999999 INCREMENT BY 1 START WITH 60 CACHE 20 ORDER NOCYCLE ;
--新建表约束
CREATE UNIQUE INDEX "unique_name" ON "table_name" ("column_name")
ALTER TABLE "table_name" ADD CONSTRAINT "unique_name" UNIQUE ("column_name")
--主键
ALTER TABLE "table_name" ADD CONSTRAINT "primarykey_name" PRIMARY KEY ("column_name")
--联合主键
ALTER TABLE "table_name" ADD CONSTRAINT "primarykey_name" PRIMARY KEY ("column_name", "column_name2")
--外键
ALTER TABLE "table_name" ADD CONSTRAINT "foreignkey_name" FOREIGN KEY ("column_name")
REFERENCES "table_name2" ("column_name2") ENABLE;
数据库表常用操作
最新推荐文章于 2024-07-26 09:40:31 发布