Sql Server快速删除多张表的所有约束的方法
declare @name varchar(500),@type varchar(10),@tbName varchar(500)
DECLARE cur CURSOR STATIC
FOR
select s.name,s.xtype,p.name tbName from sysobjects p inner join sysobjects s on s.parent_obj=p.id
where p.name like 'SC_T_%'
order by p.name
...
原创
2021-07-09 13:15:24 ·
576 阅读 ·
0 评论