sqlserver 查询所有表名+字段名

/*****  检索特定 表名+字段名  *****/


select *  from INFORMATION_SCHEMA.COLUMNS

where TABLE_NAME in  ( select name from sysobjects where type = 'U')

select *  from INFORMATION_SCHEMA.COLUMNS

where TABLE_NAME in  ( select name from sysobjects where type = 'U')

and column_name='asdasdasd'

and table_name='asdasdasd'