Saturday, 19 July 2014

Below statement will give the table names in one data base which is having SKU as a column name in a table


SELECT t.name AS table_name,
SCHEMA_NAME(schema_id) AS schema_name,
c.name AS column_name, DB_NAME() AS DB
FROM sys.tables AS t
INNER JOIN sys.columns c ON t.OBJECT_ID = c.OBJECT_ID
WHERE c.name LIKE '%SKU%'
ORDER BY schema_name, table_name;