How to create Clustered Primary Key to table?

Question Posted / saravakumar

Answers were Sorted based on User's Feedback

How to create Clustered Primary Key to table?..

Answer / 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

How to create Clustered Primary Key to table?..

Answer / saravakumar

USE [AdventureWorks]
GO
ALTER TABLE [Sales].[Individual]
ADD CONSTRAINT [PK_Individual_CustomerID]
PRIMARY KEY CLUSTERED
(
[CustomerID] ASC
)

Is This Answer Correct ?

1 Yes

1 No

More SQL Server Interview Questions

What is the difference between clustered and non-clustered indexes in ms sql server?

What is the difference between Temporary table variable and a Table variable? Or Which Table variable I should use inside Stored procedure?

How many types of TRIGGERS are there in MS SQL Server?

Define Foreign Key?

Explain differentiate between a having clause and a where clause?

What are the methods used to protect against sql injection attack?

What is the fastest way to permanently delete a 1 million row table named customers?

is it important for a database administrator to understand the operating system and file access? : Sql server administration

Tell me what is the order in which the sql query is executed?

How to select top 5 coloumn from a table without using coloumn name

What is Self Join?

Define outer join in sql server joins?

For more SQL Server Interview Questions Click Here