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

Do you know what is xpath?

1004

How to configure and test odbc dsn settings?

1100

What are various ways to enhance the ssrs report?

923

Mention the uses of stored procedures.

928

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

1081

What is the cartesian product of table?

932

How can I create a new template for import ? : sql server management studio

1025

Why do we partition data?

979

If a table does not have a unique index, can a cursor be opened on it?

874

What is conditional split?

997

Â Explain what is sql override for a source taLle in a mapping?

947

mention different types of relationships in the dbms?

964

What are entities and relationships?

923

What is the recursive stored procedure in sql server?

968

How to drop existing indexes in ms sql server?

1016