解决方案
– 获取所有数据库名
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