SQL Server的sysproperties无效，需要自定创建

双月友

于 2022-03-27 11:52:46 发布

阅读量1.2k

点赞数

分类专栏： SqlServer 文章标签：数据库开发 sysproperties

本文链接：https://blog.csdn.net/wu_zheng_peng/article/details/123770577

版权

SqlServer 专栏收录该内容

4 篇文章 0 订阅

订阅专栏

---------------------------
提示
---------------------------
出现错误！

对象名 'sysproperties' 无效。

详细信息：

.Net SqlClient Data Provider

如果出现如上的错误信息，可在数据库中执行词条语句，创建对应的视图

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,A.id,B.Name As ColName,B.colid As ColID,B.colid As  smallid,
    B.xtype As ColType,C.name As PropName,C.Value As PropValue,c.value value
    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)