sql - Identifying tables from a given database -

i have database called xyz , has many tables

now if have name of column , want know tables column present in given database, possible that?

i working on sql server

you have query information_schema sql server internal table :

select  table_name  information_schema.columns  column_name = 'columnname'