Click here to Skip to main content
Search within:



Next

Can we create Clusterted Index on foreign table
Sign Up to vote bad
good
See more: SQL2008
Can we create the clustered index on the table??
 
Can we crate non clustered index on the table?
Posted 17 Dec '12 - 6:41
rachitagarwal2828614
Add a Solution

Comments
Mika Wendelius - 17 Dec '12 - 13:52
Could you explain what you actually mean with a foreign table?

1 solution

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  
Posted 17 Dec '12 - 7:55
Abhishek Pant15K
Edited 17 Dec '12 - 7:58
v2
Add a Solution

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

  Print Answers RSS
Your Filters
Interested
Ignored
     
0 Rohan Leuva 230
1 OriginalGriff 228
2 Mahesh Bailwal 190
3 Ron Beyer 185
4 Abhinav S 168
0 Sergey Alexandrovich Kryukov 8,548
1 OriginalGriff 6,819
2 CPallini 3,648
3 Rohan Leuva 2,933
4 Maciej Los 2,288


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