Hallo, i create a view that show me the all relations (sysreferences),
but where can i find the Typ of the relation (if is a cascading deletes and
the other thinks)These relationships are treated and catalog-ed as constraints. You can use
the property name arguments CnstIsUpdateCascade and CnstIsDeleteCascade of
the meta-data function OBJECTPROPERTY to verify the referential associated
with the constraints. Check out the topic OBJECTPROPERTY in SQL Server Books
Online for more details.
Anith
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment