Can we create a clustered index on composite primary key.
- 3 Answers
- 18487 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 ? | 17 Yes | 2 No |
Post New Answer View All Answers
What is log in sql server?
How to create function without parameter in sql server?
Is ssrs support other database except ms sql server?
Can we use where clause with group by?
What command is used to rename the database?
What is fill factor and pad index?
What are different replication agents and what's their purpose? : sql server replication
how can you check the level of fragmentation on a table? : Sql server administration
What command is used to delete a table from the database in the sql server and how?
Name and describe few console utilities for ssrs?
Explain how many normalization forms?
Explain insert into select statement?
Explain about service Broker functions?
What are differences in between sql server 2012 and sql server 2016?
Which tcp/ip port does the sql server run on? How can it be changed?
