Pages

Sunday, September 15, 2013

SQL SERVER – T-SQL Script to Add Clustered Primary Key | Journey to SQL Authority with Pinal Dave

Jr. DBA asked me three times in a day, how to create Clustered Primary Key. I gave him following sample example. That was the last time he asked "How to create Clustered Primary Key to table?" USE [AdventureWorks] GO ALTER TABLE [Sales].[Individual] ADD CONSTRAINT [PK_Individual_CustomerID] PRIMARY KEY CLUSTERED ( [CustomerID] ASC ) Reference : Pinal… Continue Reading...

Source: SQL SERVER – T-SQL Script to Add Clustered Primary Key | Journey to SQL Authority with Pinal Dave