1.库表列信息
--取所有库 SELECT Name FROM Master..SysDatabases ORDER BY Name --查询所有表 select name from 库名..sysobjects where xtype in( ‘u‘,‘v‘) order by xtype,name --查询所有列 SELECT COLUMN_NAME FROM 库名.INFORMATION_SCHEMA.COLUMNS WHERE TABLE_Name = ‘表名‘
原文：https://www.cnblogs.com/SoftWareIe/p/10211668.html