Showing 3 Result(s)

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 …