2012年3月11日星期日

full text index is exist or not

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 <-

Please refer to Books Online "Obtaining Full-Text Property Values using Transact-SQL Functions" http://msdn2.microsoft.com/ms142579.aspx

In your case you should use OBJECTPROPERTY function and TableHasActiveFulltextIndex property. OBJECTPROPERTY(table_id, 'TableHasActiveFulltextIndex') will return a value of 1 when at least one column of a table is added for indexing.

Your code will look like:

SELECT OBJECTPROPERTY(OBJECT_ID('MySchema.MyTable'), 'TableHasActiveFulltextIndex');
GO

|||

Hi,

thaks Lefter, I found small solution to find index is exist or not using

sp_helpindex 'tablename'

and

fulltext index is exist or not in the table using

sp_help_fulltext_tables @.table_name='tablename'

bye

--> Murali <--

没有评论:

发表评论