Running Out Of Foreign Keys

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.

Find Foriegn Keys and their details in a database

Use this script to find all the Foriegn Keys and their details in a database

New SQL Monitor Custom Metric: Untrusted Foreign Keys

A foreign key points to a primary key that must exist in another table, for example, column X in Table 1 must also be present in Table 2. The key protects this link, and only valid data can be inserted in the foreign key column. An untrusted foreign key may threaten a database’s referential and data integrity.

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.

Ordered Loading of Databases Tables Using SSIS

Finding the load order for inserting data into a that respects referential integrity is sometimes difficult. If you are using SSIS, the task is made easier.

Create Table

FK to IDENTITY