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 is sql server locking?

936

what is raid and what are different types of raid configurations? : Sql server database administration

975

How to insert multiple rows with one insert statement in ms sql server?

1054

Can we shrink data file in sql server?

997

Explain what is raid and what are different types of raid levels?

949

How to create indexed view?

985

What is data set in report?

121

What is field with example?

869

How to create a view with data from multiple tables?

965

What are the types of joins in sql?

1055

What is SQL Azure Federations?

112

what is an index? : Sql server database administration

931

What are the five characteristics of good data?

869

What is always encrypted?

940

What is an execution plan? When would you use it?

919