Can we create clustered index on non primary key column

Answer Posted / guest

untill unless primary creating on the table we can create
cl index on a table

Is This Answer Correct ?    3 Yes 13 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the ways available in sql server to execute sql statements?

561


What command would you use to add a column to a table in sql server?

737


Can a cursor be updated? If yes, how you can protect which columns are updated?

508


What is auditing in sql server?

495


How to find out the list schema name and table name for the database?

518






What are the benefits of filtered indexes?

495


How to use the inserted and deleted pseudo tables?

533


How to see the event list of an existing trigger using sys.trigger_events?

560


Difference between aggregate functions of sql?

645


What is the cartesian product of the table?

537


Can we check locks in database? If so, how can we do this lock check?

516


What is difference between clustered index and non clustered index?

620


What is SubQuery in SQL Server 2008

539


Retrieve the unique rows from table without using UNIQUE and DISTINCT keywords.

578


Can a database be shrunk with users active?

594