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
Showing posts with label andthe. Show all posts
Showing posts with label andthe. Show all posts
Subscribe to:
Posts (Atom)