22,209
社区成员
发帖
与我相关
我的任务
分享
CREATE TABLE T(ID int,ID2 int,ID3 AS ID*ID2)
SELECT 'T' AS 表名,a.NAME AS 列名,b.text AS 公式
FROM syscolumns a,syscomments b
WHERE a.ID=OBJECT_ID('T') AND a.ID=b.ID AND a.Colid=b.number
--SS2005+
SELECT table_name = object_name(object_id),*
FROM sys.computed_columns
WHERE object_id = object_id('表名')
--SS2000
SELECT table_name = object_name(id),*
FROM syscomments
WHERE id = object_id('表名')
select * from sys.columns
use 數據庫
go
select a.Name,b.* from sysobjects a,syscolumns b where a.ID=b.ID and b.Name='formula'--字段名formula