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 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)

總結

以上是生活随笔為你收集整理的SqlServer2005/2008下sysproperties无效的解决办法的全部內容，希望文章能夠幫你解決所遇到的問題。

如果覺得生活随笔網站內容還不錯，歡迎將生活随笔推薦給好友。