Share

Column name find in full database


Find Column in full database using Column name

SELECT t.name AS table_name,
SCHEMA_NAME(schema_id) AS schema_name,
c.name AS column_name
FROM sys.tables AS t
INNER JOIN sys.columns c
ON t.object_id = c.object_id
WHERE c.name LIKE "%DeliveryDate%"
ORDER BY schema_name,
table_name;

1