Can we create clustered index on non primary key column

Answer Posted / sandeep

Yes, We can, only thing is that, we can create clustered
index only on one key.If table contains any clustered index
on any key(even on primary or on unique key) just drop it
and create it on desired key. after it you can create a non
clustered index on primary or on unique key.

Is This Answer Correct ?    4 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

explain different types of backups avaialabe in sql server? Given a particular scenario, how would you go about choosing a backup plan? : Sql server database administration

858


How to delete existing triggers using "drop trigger"?

822


What is the default value of an integer data type in sql server 2005?

797


What is a raid and what are different types of raid configurations?

913


Explain the properties of the relational tables?

770


How will you add a dimension to cube? : sql server analysis services, ssas

813


Where to find ntwdblib.dll version 2000.80.194.0?

792


What is the use of attributehierarchyvisible ? : sql server analysis services, ssas

857


How to find the second highest salary of an employee?

849


What is normalization and what are the advantages of it?

762


Can you give me some DBCC command options?(Database consistency check) - DBCC CHECKDB - Ensures that tables in the db and the indexes are correctly linked.and DBCC CHECKALLOC - To check that all pages in a db are correctly allocated. DBCC SQLPERF - It gives report on current usage of transaction log in percentage. DBCC CHECKFILEGROUP - Checks all tables file group for any damage.

2284


What are the types of resultset?

765


What is the difference between seek predicate and predicate?

813


How to create a new schema in a database?

834


What is normalization? Explain its different types?

873