Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
under2811
Constraint Violating Yak Guru
366 Posts |
 Posted - 2008-08-12 : 05:24:21
|
| I m in troble with simple questionI have two tables TableA having column col1,col2,col3 and TableB with columns col4, col5Col1 of table is Primary key and col4 of TableB is foreign key with Reference table TableA and referenced column col1Now I want to drop cluster index of col1 and again create non-cluster index on it.Please provide me correct syntaxT.I.A |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-08-12 : 09:07:38
|
| Any reasons to drop clustered index? |
 |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-08-12 : 23:53:33
|
| You can do it in ssms, just change it to non-clustered in design table page and save it. |
|
|
|
|
|
|
basic of cluster - Non-cluster index