1.检查sql表中包含的列
以下查询的列为： 列名、数据类型、最大值等
SELECT column_name as FName
,data_type as FType
,CHARACTER_MAXIMUM_LENGTH as FLen
from information_schema.columns
where table_name='Sys_Enum'
重点搜索information_schema.columns
2.查询某数据库所有表
select * from XX.sys.sysobjects where xtype='u' and name like '%Lab%'