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 <--
没有评论:
发表评论