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
5040 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 is read uncmmited?

1116

Explain sub-query?

1014

What is 1nf 2nf?

1060

How can you transfer data from a text file to a database table? Or how can you export data from a table to a comma delimited (csv) file? Or how can you import data from ms access to a table in a database? Or how can you export data from a table to an excel file?

1076

What are audit control procedures?

1034

How do you open a cluster administrator?

1097

How to provide default values to stored procedure parameters?

1104

How can you know if the row fetched from cursor is still valid in underlying table?

1047

What is the Main Difference between ACCESS and SQL SERVER?

1186

What is bit data type? What's the information that can be stored inside a bit column?

969

What is meant by referential integrity?

1047

Explain about Normalization?

1122

What is a matrix in ssrs?

158

What is scalar user-defined function?

1189

Explain what is meant by replication of database?

1106