Can we create a clustered index on composite primary key.
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 a transaction and what are acid properties? : Sql server database administration
What are actions, how many types of actions are there, explain with example? : sql server analysis services, ssas
Explain the use of keyword with encryption. Create a store procedure with encryption?
What is data modeling and Reterminal integrity?
How to insert data into an existing table?
What methods do you follow to protect from sql injection attack?
What is Extended user-defined?
Explain about service Broker functions?
Difference Between ORDER BY Clause and GROUP BY Clause in SQL?
1.how to find the dead lock in sql server? 2.How to fine the memory leaks in sql server? 3.suppose transaction log file increasing what action will take ?
What are the steps you should follow to start sql server in single-user mode?
What is ms sql server service broker?
Explain trigger classes i.e. Instead of and after trigger?
How to drop an existing stored procedure in ms sql server?
How to find a value in another dataset based on current dataset field (ssrs 2008 r2)?