Find fulltext index is exist are not

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

murali.ipr@gmail.com - 18 Jan 2006 05:19 GMT

Hi,
How to find full text index is exist in the table or not ?
like that how to find normal index is exist in the table or not ?

Thanks in adv.
---> Murali <----

Reply to this Message

Hilary Cotter - 18 Jan 2006 20:58 GMT

get the name(s) of your catalog(s) from

select name from sysfulltextcatalogs

and then do this

sp_help_fulltext_tables 'CatalogName'

Signature

Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html

Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com

> Hi,
> How to find full text index is exist in the table or not ?
> like that how to find normal index is exist in the table or not ?
>
> Thanks in adv.
> ---> Murali <----

Reply to this Message

murali.ipr@gmail.com - 21 Jan 2006 08:23 GMT

Thankyou Hilry Cotter

Reply to this Message