sqlserver查询一个库所有表的字段名及字段类型
select T_C.table_name,T_C.table_id,T_C.Column_name,T_C.Column_type_id,
systypes.name Column_type_name
from
(select sysobjects.name table_name,sysobjects.id table_id,SysColumns.name Column_name,
SysColumns.xtype Column_type_id from sysobjects
inner join SysColumns on sysobjects.id=SysColumns.id
where sysobjects.type='U') T_C
inner join systypes on T_C.Column_type_id=systypes.xtype
where systypes.xtype=systypes.xusertype
order by T_C.table_name
select sysobjects.name table_name,sysobjects.id table_id,SysColumns.name Column_name,
SysColumns.xtype Column_type_id,systypes.name Column_type_name from sysobjects
inner join SysColumns on sysobjects.id=SysColumns.id
inner join systypes on SysColumns.xtype=systypes.xtype
where sysobjects.type='U' and systypes.xtype=systypes.xusertype
order by table_name
select sysobjects.name table_name,sysobjects.id table_id,SysColumns.name Column_name,
SysColumns.xtype Column_type_id,systypes.name Column_type_name from sysobjects
inner join SysColumns on sysobjects.id=SysColumns.id
inner join systypes on SysColumns.xtype=systypes.xtype
where sysobjects.type='U' and systypes.xtype=systypes.xusertype
and systypes.name in ('datetime') --查询指定的字段类型
order by table_name
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/30126024/viewspace-2124852/ ，如需转载，请注明出处，否则将追究法律责任。
