关于sqlserver 数据库删除约束

Question

关于sqlserver 数据库删除约束

Answer 1

查询约束：SELECT * from INFORMATION_SCHEMA.TABLE_CONSTRAINTSwhere table_name in ('STUDENT','course','sc')干掉约束：alter table 表名 drop constraint 约束名