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
No comments:
Post a Comment