postgresql

移去约束

ALTER TABLE products DROP CONSTRAINT some_name;

添加一个约束

ALTER TABLE products ADD CHECK (name <> '');
ALTER TABLE products ADD CONSTRAINT some_name UNIQUE (product_no);
ALTER TABLE products ADD FOREIGN KEY (product_group_id) REFERENCES product_groups(id)  ON DELETE CASCADE/NO ACTION/RESTRICT;

• 外键也可以为空值
• 若把原件删除，默认会把相关的外键置空，若设 DELETE CASCADE 会把相关的删除