SQL schema bound objects
SQL
Download (.zip)
SELECT obj_name = SUBSTRING(OBJECT_NAME(d.id), 1, 20), dep_obj = SUBSTRING(OBJECT_NAME(d.depid), 1, 20), col_name = SUBSTRING(name, 1, 15), IsSchemaBound = CASE deptype WHEN 1 THEN 'Schema Bound' ELSE 'Free' END FROM sysdepends d JOIN syscolumns c ON d.depid = c.id AND d.depnumber = c.colid WHERE object_name(d.id) LIKE 'SalesByStore%'
|