Search particular column sql database
You can search for a particular column that present in the list of database tables in sql server.
SELECT SCHEMA_NAME(SCHEMA_ID) + '.' + TBL.NAME AS TableName, COL.NAME AS ColumnName FROM SYS.TABLES AS TBL INNER JOIN SYS.COLUMNS COL ON TBL.OBJECT_ID = COL.OBJECT_ID WHERE COL.NAME LIKE '%ENTER COLUMN NAME%' ORDER BY 1
Query to search for particular column from sql database was last modified: October 10th, 2017 by