Auto-suggesting foreign keys and data model archaeology

If you can understand the data model then you can understand the intent of the application developers.

Composite foreign key

Indexing Foreign Keys

Foreign Keys are one of the fundamental characteristics of relational databases and enforce the referential integrity. Is it a good idea to index a FK relationship? When can it help?

Delete

Show Table Parents

Which parent tables must contain rows before inserting in to TableX?

Drop and Re-Create All Foreign Key Constraints in SQL Server

Aaron Bertrand supplies a script which generates two separate sets of commands: one to drop all foreign key constraints, and one to create them again. These scripts are stored in a table so that, if you drop the constraints and then disaster of some kind strikes during the create, you still have everything handy and can troubleshoot if needed.

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.