亚洲av成人无遮挡网站在线观看,少妇性bbb搡bbb爽爽爽,亚洲av日韩精品久久久久久,兔费看少妇性l交大片免费,无码少妇一区二区三区

Chinaunix

標(biāo)題: 去除外鍵的存儲過程 [打印本頁]
作者: 堆碼狂人    時間: 2011-02-09 17:01
標(biāo)題: 去除外鍵的存儲過程
  1. create proce prdropforeignkeys
  2. @chvreferencedtable varchar(30)
  3. as
  4. declare @chvtablewithforeignkey varchar(30),
  5.             @chvforeignkey varchar(30),
  6.             @chvsql varchar(255)
  7. declare cufks cursor for
  8. select  tb.name,fk.name from
  9. ((sysobject tb inner join sysreferences r on tb.id=r.fkeyid)
  10.   inner join sysobjects fk on r.constid=fk.id)
  11.   inner join sysobjects refd on refd_tb.id=r.rkeyid)
  12. where refd_tb.name=@chvreferencedtable
  13. open cufks
  14. fetch next from cufks into @chvtablewithforeignkey,@chvforeignkey

  16. while (@@fetch_status<>-1)
  17. begin
  18.   select @chvsql='alter table'+@chvtablewithforeignkey+
  19.     'drop constraint '+@chvforeignkey
  20.   exec(@chvsql)
  21. fetch next from cufks into @chvtablewithforeignkey,@chvforeignkey
  22. end
  23. deallocate cufks
復(fù)制代碼




歡迎光臨 Chinaunix (http://72891.cn/) Powered by Discuz! X3.2