--------------------------- 对象名 '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)