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.

 All Forums
 SQL Server 2008 Forums
 Transact-SQL (2008)
 Full-Text Indexs

Author  Topic 

swoozie
Starting Member

25 Posts

Posted - 2014-07-15 : 15:21:57
I have a table with a bunch of Full-text Indexes. I have to significantly alter the table, then remove some column indexes and add others into the Full-text index. I am a little confused as to how I accomplish this as there doesnt seemt to be an easy way to even identify the existing indexes. and the Scripting tool through the gui doenst script for it.

Any suggestions?

gbritton
Master Smack Fu Yak Hacker

2780 Posts

Posted - 2014-07-16 : 07:49:33
From the GUI, you can choose Script Table As CREATE TO ... to get the indexes scripted. Also this could help:

https://stackoverflow.com/questions/3067599/script-table-as-create-via-ssms-doesnt-show-unique-index
Go to Top of Page
   

- Advertisement -