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.