-- 生成删除约束语句
select 'ALTER TABLE [' + b.name + '] drop CONSTRAINT ' + a.name +';' as 删除约束
from sysobjects a ,sysobjects b
where a.xtype ='f' and a.parent_obj = b.id and a.name like '%ON_CR_TRIANGLE_TYPE_ID'
时间:2022-09-12 16:21:32
-- 生成删除约束语句
select 'ALTER TABLE [' + b.name + '] drop CONSTRAINT ' + a.name +';' as 删除约束
from sysobjects a ,sysobjects b
where a.xtype ='f' and a.parent_obj = b.id and a.name like '%ON_CR_TRIANGLE_TYPE_ID'
Sqlserver SQL语句 表字段 增删改.以及约束的删除与添加
2022-02-26
用SQL语句在数据库中对表的列进行添加 修改 删除及增加约束
2022-12-15
SQL DDL 生成建表语句(可自动生成主键约束 字段默认值等)
2024-04-12