34,576
社区成员
发帖
与我相关
我的任务
分享
SELECT *
FROM syscolumns
WHERE (id = OBJECT_ID('spt_monitor'))
SELECT *
FROM systypes
WHERE (xtype = xusertype) AND (xtype IN
(SELECT xtype
FROM syscolumns
WHERE id =
(SELECT id
FROM sysobjects
WHERE name = 'spt_monitor' AND xtype = 'U')))
--獲取表spt_monitor的所有字段
SELECT *
FROM syscolumns
WHERE (id = OBJECT_ID('spt_monitor'))
select object_name(id) as 表名
,c.name as 字段名
,t.name 数据类型
,c.prec as 长度
from syscolumns c
inner join
systypes t
on c.xusertype=t.xusertype
where objectproperty(id,'IsUserTable')=1 and id=object_id('tb')
/*
表名 字段名 数据类型 长度
-------------------------------------------------------------------------------------------------------------------------------- -------------------------------------------------------------------------------------------------------------------------------- -------------------------------------------------------------------------------------------------------------------------------- ------
tb id int 10
tb sid varchar 10
tb course varchar 10
tb result float 53
*/