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
Resources
Read more here…
Add to favorites
