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

How to create Clustered Primary Key to table?

Question Posted / sarika jayadave

2 Answers
4948 Views
I also Faced
E-Mail Answers

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

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What are the benefits and tasks of object explorer? : sql server management studio

1184

What are the different types of replication you can set up in sql server?

1052

What is a cache in ssrs?

134

How much memory that we are using in Logshipping Concept?

1797

What are the basic functions for master, msdb, model, tempdb databases?

1047

How to create a new schema in a database?

1152

Give me any three differences between Truncate and Delete.

1107

List the different index configurations possible for a table?

934

Tell me what is the difference between locking and multi-versioning?

1032

What do you understand by user-defined function in the sql server and explain the steps to create and execute a user-defined function in the sql server?

968

Can you explain what is indexed view? How to create it?

908

How to insert data into an existing table?

981

What is the difference between a function and a stored procedure?

1074

I have triggers,views,functions,stored Procedures for a table. When I am dropping that table which objects are deleted?

1141

What is sql stored procedure?

1099