It's Not All About The Keys

List Table Foreign Keys, Primary key and indexes

This procedure let you list [optional] by table:
-Foreign keys
-Primary key
-Indexes

Get all the Child Tables up to N level

Get all the dependent tables for a master table up to N level(Till the leaf ) you can either find dependency or you can find all the child tables.

Re-Trust Untrusted Foreign Keys and Constraints

This script will attempt to re-trust untrusted foreign keys and will report counts of successes and failures.

FK to IDENTITY

Rename Foreign Key Constraints

Rename Foreign Key Constraints in a consistent manner. Ideal for preventing constraint errors during code promotion.

Duplicate Foreign Key

Find Foreign Keys

Lists the foreign keys between tables in the datavase,

Foreign key

Violating Foreign Keys