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"