Click here to Skip to main content
12,301,899 members (56,070 online)
Rate this:
 
Please Sign up or sign in to vote.
Can we create the clustered index on the table??

Can we crate non clustered index on the table?
Posted 17-Dec-12 6:41am
Comments
Mika Wendelius 17-Dec-12 13:52pm
   
Could you explain what you actually mean with a foreign table?

1 solution

Rate this: bad
 
good
Please Sign up or sign in to vote.

Solution 1

Yes,
but according to clustered index defination-
Quote:
A clustered index defines the order in which the data should be stored in the database. This means that there can only be one clustered index per table.


SQL Server script to auto-create indexes on all Foreign Key[^]
Indexes Supporting Foreign Keys[^]
  Permalink  
v2

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

  Print Answers RSS
Top Experts
Last 24hrsThis month


Advertise | Privacy | Mobile
Web01 | 2.8.160525.2 | Last Updated 17 Dec 2012
Copyright © CodeProject, 1999-2016
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100