You can also do this. create table Test (officeid integer not null, e

Can we create a clustered index on composite primary key.

Question Posted / monal

3 Answers
19622 Views
IGT, I also Faced
E-Mail Answers

Answer Posted / monal

You can also do this.

create table Test
(officeid integer not null,
empid integer not null,
age integer ,
sex varchar(5),
name varchar(20),
PRIMARY KEY (OFFICEID, EMPID))

this will also create composite primary key and cluster
index on composite primary key.

Is This Answer Correct ?

18 Yes

2 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is dml command?

976

Show Practically Sql Server Views are updatable?

1128

What is mean by dml?

1017

Using the customer, and order table in northwind database, please write a query to produce xml?

1079

What is the downside of using udf?

1110

Find nth lowest salary or get nth lowest salary?

1029

How can I change procedure name in sql server?

1053

Can we insert data if clustered index is disabled?

943

What is the purpose of sql profiler in sql server? : sql server database administration

1111

Can you explain what are commit and rollback in sql?

944

What is compression - row-level and page-level compression?

920

Describe in brief authentication modes in sql server.

1032

How to update a field in SQL after ALTERING a row?

1235

What is resource governor?

976

What is a schema in ms sql server 2005?

975