How to create Clustered Primary Key to table?

Question Posted / saravakumar

2 Answers
4818 Views
I also Faced
E-Mail Answers

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

Post New Answer

More SQL Server Interview Questions

Can sql servers link to other servers?

0 Answers

How to create function without parameter in sql server?

0 Answers

Say if we have a table that contains only a single column , say OrderID, which has IDENTITY attribute defined on it. So how can we insert data in this table. I am reframing my question, that how can we make the table to increment the column "OrderID" value several times???

3 Answers

What are the default system databases in sql server 2000?

0 Answers

What is dimension table? : sql server analysis services, ssas

0 Answers

We create an index to fast the search. How it fast the query? Do we write any special keyword with query?

3 Answers

Explain fundamentals of Data ware housing & OLAP?

2 Answers

How many columns can we include on clustered index ?

0 Answers

What are ddl (data definition language) statements for tables in ms sql server?