查看表与视图的依赖
发布时间：2020-12-13 20:16:01 所属栏目：百科 来源：网络整理
导读：alter function F_Get_DepentTable_Ralation ( @table sysname ) /* 查看表与视图的依赖 */ returns table as return( SELECT sysobjects.name AS 'view',sysobjects_1.name AS 'depend table' FROM sysobjects INNER JOIN sysdepends ON sysobjects.id = sys
|
alter function F_Get_DepentTable_Ralation ( @table sysname ) /* 查看表与视图的依赖 */ returns table as return( SELECT sysobjects.name AS 'view',sysobjects_1.name AS 'depend table' FROM sysobjects INNER JOIN sysdepends ON sysobjects.id = sysdepends.id INNER JOIN sysobjects sysobjects_1 ON sysdepends.depid = sysobjects_1.id WHERE (sysobjects.xtype = 'v') AND (sysobjects_1.name = @table) GROUP BY sysobjects.name,sysobjects_1.name) （编辑：李大同） 【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容! |