oracle中的修改命令

ALTER TABLE products ADD COLUMN description text CHECK (description <> '');增加字段

ALTER TABLE products DROP COLUMN description; 删除字段

ALTER TABLE products ADD CHECK (name <> ''); 增加约束

ALTER TABLE products ADD CONSTRAINT some_name UNIQUE (product_no);增加约束

ALTER TABLE products ADD FOREIGN KEY (子表字段) REFERENCES 主表（主表字段） on delete casecade;增加约束

ALTER TABLE products DROP CONSTRAINT some_name;删除约束

ALTER TABLE products ALTER COLUMN price SET DEFAULT 7.77; 改字段默认值

ALTER TABLE products ALTER COLUMN price DROP DEFAULT; 去掉默认值

ALTER TABLE products ALTER COLUMN price TYPE numeric(10,2);改字段类型

ALTER TABLE products RENAME COLUMN product_no TO product_number;改字段名

ALTER TABLE products RENAME TO items; 改表名