check if filed exists in all tables in current DB

SELECTt.name  AS table_name,

SCHEMA_NAME(t.schema_id)AS schema_name,

c.nameAS column_name , types.name, c.max_length

FROMsys.tables AS t

INNERJOIN sys.columns c ON t.OBJECT_ID = c.OBJECT_ID

innerjoin sys.types types on types.system_type_id = c.system_type_id

WHEREc.name LIKE '%Abc%' or c.name like '%abc%'

ORDERBY schema_name, table_name 

察看全数据库是否有某个字段