Skip to content

Instantly share code, notes, and snippets.

@arekgotfryd

arekgotfryd/Add unique (auto-incremented) primary key to existing table

Created September 11, 2019 08:01
Show Gist options
  • Save arekgotfryd/9bd6e362a163cb9170480a0e39550bf8 to your computer and use it in GitHub Desktop.
Save arekgotfryd/9bd6e362a163cb9170480a0e39550bf8 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
Add unique (auto-incremented) primary key to existing table
ALTER TABLE dbo.YourTable
ADD ID INT IDENTITY
CONSTRAINT PK_YourTable PRIMARY KEY CLUSTERED
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment