Interested to Buy Any Domain ? << Click Here >> for more details...
Can we create a clustered index on composite primary key.
- 3 Answers
- 19384 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
What is a bit datatype?
What is buffer cash and log cache in sql server?
You want to implement the many-to-many relationship while designing tables. How would you do it?
Why we use functions in sql server?
Explain what is use of dbcc commands?
What is mean by candidate key?
What do we need queues in sql service broker?
can any body tell me how to know the password of current user in sql server
How to find the version of sql server? : sql server database administration
What is the difference between web edition and business edition?
What is coalesce in sql server?
how would you troubleshoot blocking? : Sql server database administration
Explain few examples of stored procedure over triggers?
What are constraints in microsoft sql server?
what are database files and filegroups? : Sql server database administration
