SQL schema bound objects

schema bound objects

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%'