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 data modeling and Reterminal integrity?

1951

How to select true false based on column value in sql server?

1009

Why is sql server log file full?

1024

What are the different index configurations a table can have?

954

New concepts of sql server 2005 use in your project.

2354

What does it mean to normalize a database and why would you do it?

975

How do you delete duplicate records in sql server?

1043

Describe in brief sql server monitoring ways.

1044

Can we do dml on views?

948

What are relationships and mention different types of relationships in the dbms

956

What is a mixed extent?

1003

What is a trace frag?

1074

What is the difference between createstatement and preparedstatement?

927

what stored procedure can you use to display the current processes? : Sql server administration

1003

What are binary string data types in ms sql server?

1270