SqlServer2005/2008下sysproperties无效的解决办法

发布时间：2020-12-12 13:30:18 所属栏目：MsSql教程来源：网络整理

导读：SqlServer2005/2008下sysproperties无效的解决办法 if exists (select 1 from sysobjects where name = 'sysproperties'and xtype = 'v') begin ? ? drop view sysproperties end ? ? go ? ? create view sysproperties ? ? as ? ? select a.name as tablena

if exists (select 1 from sysobjects where name = 'sysproperties'and xtype = 'v')

begin ? ? drop view sysproperties end ? ? go ? ? create view sysproperties ? ? as ? ? select a.name as tablename,? ? a.id as tableid,b.name as colname,b.colid as colid,? ? b.xtype as coltype,c.name as propname,c.value as propvalue ? ? from sysobjects as a inner join syscolumns as b on a.id = b.id ? ? inner join sys.extended_properties as c on c.major_id = a.id? ? ? and ( minor_id = b.colid)

（编辑：李大同）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!