昨晚进论坛说维护,不知怎么回事.一早起来就回复 SELECT text FROM syscomments s WHERE id=OBJECT_ID('wage') 是这样text就是计算列的公式
对的,这是显示单个数据库表的所有字段,还有一个显示某数据库的所有表和字段SELECT CONVERT(varchar(20), a.id) + '_' + CONVERT(varchar(20), a.colid) AS FID, a.id AS FTableID, b.name AS FTableName, a.colid AS FColID, a.name AS FColName, c.[value] AS FColDesc, a.xtype AS FTypeID, d.name AS FTypeDesc, a.length AS FLength FROM dbo.syscolumns a INNER JOIN dbo.sysobjects b ON b.id = a.id AND b.xtype = 'U' AND b.status > 0 LEFT OUTER JOIN dbo.sysproperties c ON c.id = a.id AND c.smallid = a.colid AND c.type = 4 LEFT OUTER JOIN dbo.systypes d ON d.xtype = a.xtype
when 1 then 'int'
....
34 image
35 text
36 uniqueidentifier
48 tinyint
52 smallint
56 int
58 smalldatetime
59 real
60 money
61 datetime
62 float
98 sql_variant
99 ntext
104 bit
106 decimal
108 numeric
122 smallmoney
127 bigint
165 varbinary
167 varchar
173 binary
175 char
189 timestamp
231 sysname
231 nvarchar
239 nchar
SELECT text FROM syscomments s WHERE id=OBJECT_ID('wage')
是这样text就是计算列的公式
a.id AS FTableID, b.name AS FTableName, a.colid AS FColID, a.name AS FColName,
c.[value] AS FColDesc, a.xtype AS FTypeID, d.name AS FTypeDesc,
a.length AS FLength
FROM dbo.syscolumns a INNER JOIN
dbo.sysobjects b ON b.id = a.id AND b.xtype = 'U' AND
b.status > 0 LEFT OUTER JOIN
dbo.sysproperties c ON c.id = a.id AND c.smallid = a.colid AND
c.type = 4 LEFT OUTER JOIN
dbo.systypes d ON d.xtype = a.xtype