Welcome to Sign in | Help
in Search

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

Last post 12-21-2006, 12:46 PM by Jourjaque. 1 replies.
Sort Posts: Previous Next
  •  01-18-2006, 4:01 PM 2

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

    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

    Cristian Andrei Lefter, SQL Server MVP
    MCT, MCSA, MCDBA, MCAD, MCSD .NET,
    MCTS, MCITP - Database Administrator SQL Server 2005
    http://sqlserver.ro
  •  12-21-2006, 12:46 PM 1409 in reply to 2

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

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

    MCSE;MCITP
View as RSS news feed in XML
Powered by Community Server (Commercial Edition), by Telligent Systems