I am new to SQL Server and working on a new Data Base. I need to search the SQL Server database and list all Table names that have a Field I am looking for.
In Oracle I would do
SELECT column_name, Table_name FROM all_tab_columns
WHERE column_name = 'POS_TRANSACTION' ----Name_Of_Field from tables that I'm looking for
This will list all tables that have the field name.
How do I do this in SQL Server?