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

How can you insert values in multiple rows using one Insert statement?

1079

How you can change the database name in SQL SERVER?

1175

What is a sql join?

1000

Explain can SSRS reports Cache results?

158

How to recreate an existing index in ms sql server?

1032

What are the new scripting capabilities of ssms? : sql server management studio

1044

Distinguish between nested subquery and correlated subquery?

1026

Do you know what are various aggregate functions that are available?

1095

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

1038

What is Cross Join and in which scenario do we use Cross Join?

1003

How to get a list of columns in a view using the "sp_help" stored procedure?

1024

How do you test your database? : sql server database administration

991

How to verify the port number of the sql server?

1126

What is right outer join in sql server joins?

1159

What is raiseerror? What is raiseerror?

1119