Can we create clustered index on non primary key column
- 20 Answers
- 51430 Views
- ABC, CTS, I also Faced
- E-Mail Answers
Answer Posted / pavan kumar
YES, We can create a clustered index on a non-primary
column. Check the folowing queries...
CREATE TABLE EMPLOYEES
(
empid int NOT NULL CONSTRAINT ix_pkEMPLOYEES PRIMARY KEY
NONCLUSTERED
, name varchar(25) NOT NULL
, age tinyint NOT NULL
)
CREATE CLUSTERED INDEX ixcEMPLOYEES ON EMPLOYEES (name)
| Is This Answer Correct ? | 57 Yes | 6 No |
Post New Answer View All Answers
What are horizontal and vertical scaling?
I have triggers,views,functions,stored Procedures for a table. When I am dropping that table which objects are deleted?
What is acid db?
Where does the copy job runs in the log shipping primary or secondary? : sql server database administration
How to compose an inquiry to demonstrate the points of interest of an understudy from students table whose name begins with k?
What is sql server english query?
How raid can influence database performance?
How you can change the database name in SQL SERVER?
What are system databases into sql server (2005/2008)?
What is a trigger what are the advantages of trigger?
What is mscorsvw.exe - process - microsoft .net framework ngen?
Define candidate key, alternate key, and composite key.
How to get the definition of a trigger back?
What happens if an integer is too big for int date type?
do you know how to configure db2 side of the application? : Sql server database administration
