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 are the differences between substr and charindex in sql server.

1186

Why do we use non clustered index?

1132

How can we improve performance by using SQL Server profiler?

1108

What is raiseerror? What is raiseerror?

1193

What is the maximum row of a size?

1068

What is the status of services on passive node for failover cluster in sql server? : sql server database administration

1351

Difference between LEN() and DATALENGTH() in sql server ?

1170

How do I create a partition table in sql server?

1182

What is the most common type of join?

1038

How to send email from database?

1071

How do you clear a log file?

1108

Find columns used in stored procedure?

1038

What are the three different part of rdl file explain them?

276

Explain datetime2 data type in sal server 2008?

951

What is an expression in ms sql server?

1141