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

Explain about sql server login?

1067

What is primary key and example?

934

What is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure?

984

How can you find out how many rows returned in a cursor?

1007

Is sql server a database?

960

What is a constant or literal in ms sql server?

1029

what is an extended stored procedure? : Sql server database administration

1037

Define a cross join?

990

How are the exceptions handled in sql server programming?

1046

A trigger can reference objects outside the current database? State true or false.

992

where can you add custom error messages to sql server? : Sql server administration

1087

How to write a query with an inner join in ms sql server?

1026

What will happen if a column containing char type data is changed to the nchar data type?

1080

How to insert data into an existing table?

962

Write a sql query to display the current date?

1078