Interested to Buy Any Domain ? << Click Here >> for more details...
Can we create clustered index on non primary key column
- 20 Answers
- 54113 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
Can we check locks in database? If so, how can we do this lock check?
What are the pre-defined functions in the sql server?
Tell me what do you understand by a view? What does the with check option clause for a view do?
How to turn on the mssql api module in php?
Which is faster statement or preparedstatement?
What is after dml trigger?
Where can you add custom error messages to sql server?
What is a primary key?
How many types of subqueries are there in sql server?
Explain what is meant by replication of database?
What are a scheduled jobs or what is a scheduled tasks?
how do you test proper tcp/ip configuration windows machine? : Sql server database administration
What are the advantages of user defined function?
Tell me what are the essential components of sql server service broker?
Explain what is analysis service repository?
