Recently i had to search for a specific column in database. My assumption was that the column name would be same as the column name in parent table. For example Person table PersonID column would be name same in all reference tables.
USE MyDatabase --find all columns with a specific name in database SELECT OBJECT_SCHEMA_NAME(ac.object_id) SchemaName, OBJECT_NAME(ac.object_id) TableName, ac.name as ColumnName, tp.name DataType FROM sys.all_columns ac INNER JOIN sys.types tp ON tp.user_type_id = ac.user_type_id WHERE ac.name = 'YourColumnName' GO
Read more here…Add to favorites