Find Primary Column of all tables in database

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

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.

Do You Really Need Surrogate Keys? Part 1 – Concepts and Methods

This is the first of a series of articles to analyze the use of surrogate keys in different scenarios.

Predict the outcome

Getting unique or primary key columns for a given table

Following script will list out all the columns which have unique/primary key constraints for a given table.

Generate Insert Statements

This script Generates the insert statements for a particular table.