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; 改表名