Find a column from all tables in a database on SQL Server
I recently have needed to find a column but could not remember what table it was in the database. You can run this query on your SQL Server to find a specific column in the whole database: SELECT COLUMN_NAME, TABLE_NAME FROM INFORMATION_SCHEMA.COLUMNS WHERE COLUMN_NAME LIKE’ %ColumnName%’ You will need to replace the ColumnName(that is in …