Re: How to check if full-text indexes exist on a table?

Jourjaque — Thu, 21 Dec 2006 10:46:38 GMT

An alternate method :: Storage -> Full-Text Catalogs and you can see everything....tables,columns,indexes !

How to check if full-text indexes exist on a table?

xmldeveloper — Wed, 18 Jan 2006 14:01:13 GMT

Using OBJECTPROPERTY function and TableHasActiveFulltextIndex parameter. OBJECTPROPERTY(table_id, 'TableHasActiveFulltextIndex') will return a value of 1 when at least one column of a table is added for indexing.
CODE:

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

REFERENCE: "Obtaining Full-Text Property Values using Transact-SQL Functions" http://msdn2.microsoft.com/ms142579.aspx

Full-Text Search

Re: How to check if full-text indexes exist on a table?

How to check if full-text indexes exist on a table?