USE [AdventureWorks] GO ALTER TABLE [Sales].[Individual] ADD CONSTRAINT

How to create Clustered Primary Key to table?

Question Posted / saravakumar

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

Please Help Members By Posting Answers For Below Questions

What do you mean by acid?

568

What is transact-sql language?

574

Explain difference between cross join and full outer join?

552

When you should use a low fill factor?

514

Can binary strings be used in arithmetical operations?

519

Explain the advantages of merge replication?

501

What is deploy, process and build? : sql server analysis services, ssas

562

How to select some specific rows from a table in ms sql server?

564

What languages bi uses to achieve the goal?

506

How can I track the changes or identify the latest insert-update-delete from a table?

533

What gets stored inside msdb database?

760

Does dbcc checkdb requires db to be in single_user mode? : sql server database administration

514

what is denormalization and when would you go for it? : Sql server database administration

697

Is it ok to shrink transaction log?

508

What are the two modes of authentication in sql server?

516