List Table Foreign Keys, Primary key and indexes

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

Primary Key Primer for SQL Server

Every database developer uses keys, but without always understanding all the ramifications. They come with few hard and fast rules, but if you get them right from the start with a database design, the whole process of database development is simpler, and the result is likely to perform better. We asked Phil for advice, little knowing that the explanation might take a while.

Primary Keys which are not Clustered Indexes in a database

Recently I was asked to find all the Primary keys that are not clustered Indexes in the database. I constructed the below script which will help us to locate the primary keys in the database which are not clustered index.

BIT Primary Key

T-SQL

Find Primary Column of all tables in database

This code helps in finding Primary Keys for all tables in a database.

Primary Keys

Check if Constraint is enabled or disabled

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

Find gaps in primary keys across multiple databases

Output table of gaps in a primary key across multiple databases on same, remote and/or linked servers.

Columns Explorer - With constraints create / drop scripts (no cursors)

Gets all columns infos, foreign keys (multicolumn fk handled), referenced primary keys, default and check constraints, indexes, Create/Drop scripts for all constraints.