Can we create clustered index on non primary key column
- 20 Answers
- 51415 Views
- ABC, CTS, I also Faced
- E-Mail Answers
Answer Posted / suraj
-- YES.
drop table Employees
create table Employees(
EmpID int Primary Key NonClustered,
[Name] varchar(20),
SSNo varchar(20) )
CREATE CLUSTERED INDEX ci_EMPLOYEES_SS ON EMPLOYEES (Name)
insert Employees values (101,'John','123-45-6789')
insert Employees values (102,'Mike','123-45-6789')
select * from Employees
-- We have to specifically define NonClustered in the
Primary Key column because Clustered Index is created by
default in Primary Key.
-- And, We are able to define Clustered Index in
another column because every table is eligible to have one
clustered index.
-- Clustered Index has to be created after table
creation.
-- From above example, EmpID doesn't take duplicates,
because it is primary key. But, SSNo takes duplicates.
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
What is replication and database mirroring?
what authentication modes does sql server support? : Sql server database administration
What is an index in sql?
What is sql profiler. What are the default templates with it? : sql server database administration
What happens if ntwdblib.dll is missing on your machine?
Describe the left outer join & right outer join. : sql server database administration
Explain about link server in sql server?
What is checkpoint process in the sql server?
What is store procedure?
How to provide column names in insert statements in ms sql server?
when you create a database how is it stored? : Sql server database administration
you have separate development and production systems you want to move a copy of a development database into production to do this, you do a backup on the development system and restore to the production system after a few minutes, you begin getting calls from several customers saying that they are denied access to the system why? : Sql server administration
Does sql server use java?
What are the differences between ms sql server & oracle?
What is sleeping status in sql server?
