如何用SQL查找 数据库中所有表格里，数据类型为varchar 的 字段？

Question

我先试试看，希望操作系统表可以解决这个问题。

Answer 1

select a.name as [column],b.name as type
from syscolumns a,systypes b
where a.id=object_id('表名') and a.xtype=b.xtype

把“表名”替换成你要查看字段类型的表名，比如你要查看sysobjects表的各字段类型那么就是
select a.name as [column],b.name as type
from syscolumns a,systypes b
where a.id=object_id('sysobjects') and a.xtype=b.xtype

另外可以通过存储过程
exec sp_help 表名

Answer 2

select name from syscolumns
where type=39

Answer 3

select * from syscolumns a,sysobjects b,systypes c
where a.id = b.id
and a.xtype = c.xtype
and b.name= '表名'
and c.name = 'varchar'