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

Check if Constraint is enabled or disabled

This is a script to find all constraints and check if they are enabled or disabled.

Holy Foreign Keys and Indexes

This article shows an interesting issue with foreign keys and how they are aligned with the base tables in SQL 2005 SP 4.