如何获取SQL Server所有的数据库名、表名、字段名及字段类型？

解决方案

– 获取所有数据库名
select name from master..sysdatabases

– 获取所有表名
select name from YDK..SysObjects where XType=’U’ order by name

– 获取字段名
select * from SysColumns where id=Object_id(‘YDS_XMXX’) order by name

– 获取字段类型
select column_name,data_type from information_schema.columns
where table_name=’YDS_XMXX’ and column_name=’XMMC’

– 获取表主键
Select name FROM SysColumns Where id=Object_Id(‘表名’) and colid=(select top 1 keyno from sysindexkeys where id=Object_Id(‘表名’))

参考

http://gbjian001.iteye.com/blog/725889
http://topic.csdn.net/t/20020902/11/988813.html