SELECT Sysobjects.name AS [数据表名], syscolumns.name AS [列名], systypes.name AS [数据类型], syscolumns.length AS [字段长度], sys.extended_properties.[value] AS [字段描述], syscomments.text AS [默认值],syscolumns.isnullable AS [是否允许空值] FROM syscolumns INNER JOIN systypes ON syscolumns.xtype = systypes.xtype LEFT JOIN sysobjects ON syscolumns.id = sysobjects.id LEFT OUTER JOIN sys.extended_properties ON ( sys.extended_properties.minor_id = syscolumns.colid AND sys.extended_properties.major_id = syscolumns.id) LEFT OUTER JOIN syscomments ON syscolumns.cdefault = syscomments.id WHERE syscolumns.id IN (SELECT id FROM SYSOBJECTS WHERE xtype = 'v' AND NAME = 'vAdhocActivities') AND (systypes.name <> 'sysname') ORDER BY syscolumns.colid这个是最详细的了。
systypes.name AS [数据类型], syscolumns.length AS [字段长度],
sys.extended_properties.[value] AS [字段描述], syscomments.text AS
[默认值],syscolumns.isnullable AS [是否允许空值] FROM syscolumns
INNER JOIN systypes
ON syscolumns.xtype = systypes.xtype
LEFT JOIN sysobjects ON syscolumns.id = sysobjects.id
LEFT OUTER JOIN sys.extended_properties ON
( sys.extended_properties.minor_id = syscolumns.colid
AND sys.extended_properties.major_id = syscolumns.id)
LEFT OUTER JOIN syscomments ON syscolumns.cdefault = syscomments.id
WHERE syscolumns.id IN
(SELECT id FROM SYSOBJECTS WHERE xtype = 'v' AND NAME = 'vAdhocActivities') AND (systypes.name <> 'sysname')
ORDER BY syscolumns.colid这个是最详细的了。
貌似只有获取到视图的SQL后自己处理,
第二点就是3楼的那个SQL就可以了,
直接在系统表里面抓.