Answer / 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.

Answer / anil kumar

Here's the procedure:

Create a table with no primary key defined.
Create clustered index on the primary key columns.
Alter the table to define the primary key.

Table creation:

create table CDSWEB.Anil (officeid integer not null,
empid integer not null,
age integer ,sex varchar(5),
name varchar(20));

Index creation:
create index CDSWEB.AN001 on CDSWEB.Anil(officeid,empid)
CLUSTER;

Primary key defined:

alter table CDSWEB.ANIL
add primary key (officeid,empid);

Answer / shatrunjay shukla

Yes
If you are creating a composite Primary Key, or a composite Clustered Index that is NOT a Primary Key, you are creating a single index that uses both column values as the clustering key.

CREATE TABLE T(id INT, cat INT, uName SYSNAME);

CREATE UNIQUE CLUSTERED INDEX ix_T_id_cat ON T (id,cat);



SELECT * FROM SYS.INDEXES WHERE object_id = OBJECT_ID('T');

What is instead of trigger sql server?

0 Answers  

---

what is the information that can be stored inside a bit column? : Sql server database administration

0 Answers  

---

Can you link only other SQL Servers or any database servers such as Oracle?

1 Answers  

---

What is the difference between deallocate cursor and close cursor?

0 Answers  

---

Which are the new data types introduced in sql server 2008?

0 Answers  

---

What is difference between global temporary tables and local temporary tables?

0 Answers   Tech Mahindra,

---

1.How to check the backup file details if we do not have access to that folder 2.how to check the backup file size without connecting to the folder

3 Answers   CarrizalSoft Technologies, IBM,

---

Can we add an identity column to decimal datatype?

0 Answers  

---

What are the different ways of moving data/databases between servers and databases in SQL Server?

1 Answers  

---

What is use of @@ spid in sql server?

0 Answers  

---

How to loop through result set objects using odbc_fetch_row()?

0 Answers  

---

What is coalesce in sql server?

0 Answers  

---