Search the Column on the DB (SQL Server)

          To find a particular column from all the tables available on the particular  DB, We can use the following sql query :

SELECT tab.name AS table_name,

col.name AS column_name

FROM sys.tables AS tab

INNER JOIN sys.columns col ON tab.object_id  = col.object_id

WHERE col.name LIKE '%SalesDoc%'  -- Column Name