Code Library
Home Submit Free Hosting Link To Us Contacts

SQL schema bound objects

SQL schema bound objects SQL SQL schema bound objects 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%'




  • SQLschema bound objects


SQL schema bound objects