USE <DATABASE NAME> GO ALTER TABLE [SERVER NAME].[TABLE NAME] ADD

How to create Clustered Primary Key to table?

Question Posted / sarika jayadave

Answer Posted / sarika jayadave

USE <DATABASE NAME>
GO
ALTER TABLE [SERVER NAME].[TABLE NAME]
ADD CONSTRAINT [PRIMARY KEY NAME]
PRIMARY KEY CLUSTERED
(
[ORDER BY FILED NAME] ASC
)

Is This Answer Correct ?

3 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What are views used for?

1008

Tell me about pre-defined functions of sql?

1105

What are the differences in Clustering in SQL Server 2005 and 2008 or 2008 R2?

1036

What is serializable?

1034

Define tempdb database?

984

What are the system database in sql server 2005?

1035

Explain user defined views?

949

What are system databases into sql server (2005/2008) : sql server database administration

999

What are the 2 types of classifications of constraints in the sql server?

1112

How do I get to sql server configuration manager?

1001

Is t sql the same as sql server?

955

What are translations and its use? : sql server analysis services, ssas

1034

What are rest-style architecture's?

170

How can I add Reporting Services reports to my application?

129

What is the difference between TRUNCATE and DROP?

1126