USE [AdventureWorks] GO ALTER TABLE [Sales].[Individual] ADD CONSTRAINT

How to create Clustered Primary Key to table?

Question Posted / saravakumar

Answer Posted / saravakumar

USE [AdventureWorks]
GO
ALTER TABLE [Sales].[Individual]
ADD CONSTRAINT [PK_Individual_CustomerID]
PRIMARY KEY CLUSTERED
(
[CustomerID] ASC
)

Is This Answer Correct ?

1 Yes

1 No

Please Help Members By Posting Answers For Below Questions

What is use of except clause? How it differs from not in clause?

1021

What is the purpose of sql profiler in sql server? : sql server database administration

1111

What are the character string functions supported by sql server 2005?

1016

Explain difference between cross join and full outer join?

1010

What are constraints?

1015

What is a mixed extent?

1030

How to turn off warning messages during php execution?

1046

What are policy management terms?

985

What program is used to store the data source file?

964

How does index makes search faster?

979

Explain some stored procedure creating best practices or guidelines?

937

How to create stored procedures with parameters in ms sql server?

1082

Is sql different from sql server?

1094

What happens if null values are involved in bitwise operations?

1030

Explain the etl (extraction, transformation, and loading)?

998