sql查询某列的数据类型和列的总数

Question

比如一个表里怎样查出他是否是字符串，整数，逻辑型或者其他的数据类型的。好有就是怎样才能查询到一个表里她有几列，就是有几个字段数。谢谢各位高手了！

Answer 1

SELECT TOP 100 PERCENT c.colid AS 序号, o.name AS 表名, c.name AS 列名,
t.name AS 类型, c.length AS 长度, c.isnullable AS 允许空,
CAST(m.[value] AS Varchar(100)) AS 说明
FROM dbo.syscolumns c INNER JOIN
dbo.sysobjects o ON o.id = c.id AND objectproperty(o.id, 'IsUserTable') = 1 AND
o.name <> 'dtproperties' INNER JOIN
dbo.systypes t ON t.xusertype = c.xusertype LEFT OUTER JOIN
dbo.sysproperties m ON m.id = o.id AND m.smallid = c.colorder
ORDER BY o.name, c.colid

Answer 2

select count(name) from syscolumns where id=(select id from sysobjects where xtype='u' and name='表名')