Interested to Buy Any Domain ? << Click Here >> for more details...
Can we create a clustered index on composite primary key.
- 3 Answers
- 19748 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
Do you know how to make remote connection in database?
What is the use of for clause?
How to list all login names on the ms sql server?
When would you use it?
When would you use sql joins?
Explain the Ways to improve the performance of a sql azure database?
How to get the query of a table in sql server?
how to control the amount of free space in your index pages? : Sql server database administration
Can a table have 2 foreign keys?
How many tables can be joined in SQL Server?
What is difference between clustered and non clustered index?
What is the syntax to execute the sys.dm_db_missing_index_details? : sql server database administration
How many columns can exist together per table?
What is a mutating table error and how can you get around it?
How to list all stored procedures in the current database using ms sql server?
