SQL Server 2008中在设计每个表的字段时,使用英文字段名称,然后使用他的Description属性来保存这个字段的中文名称,在程序中,调用这些中文名称
执行
SELECT o.[name] AS tables, c.[name] AS [columns], p.value AS properties
FROM sysproperties p INNER JOIN
sysobjects o ON o.[id] = p.[id] INNER JOIN
syscolumns c ON c.[id] = p.[id] AND c.colid = p.smallid
ORDER BY 1提示:Invalid object name sysproperties .请高手指教,问题出在哪里了!谢谢!
执行
SELECT o.[name] AS tables, c.[name] AS [columns], p.value AS properties
FROM sysproperties p INNER JOIN
sysobjects o ON o.[id] = p.[id] INNER JOIN
syscolumns c ON c.[id] = p.[id] AND c.colid = p.smallid
ORDER BY 1提示:Invalid object name sysproperties .请高手指教,问题出在哪里了!谢谢!
2008 用 sys.extended_properties
--AND t.name='表名' --省略这个条件可以显示全表
本文来自CSDN博客,转载请标明出处:http://blog.csdn.net/htl258/archive/2009/04/28/4131915.aspx