Post reply

How to alter FULLTEXT INDEX on table ?

  • December 11, 2008 at 12:34 am

    #94281

    Hi

    I have created the fulltext index on Address table by following way -

    create fulltext index on address

    (

    address

    )

    key index pk_address on FTAddress

    with change_tracking auto

    Now, I want to alter it.

    Insted of only address, i want to add following columns City,State & Country on it.

    How can i do this ?

  • December 11, 2008 at 7:55 am

    #911098

    This is what I got from SSMS 2008, similar idea

    I usually always use the SSMS to configure full-text (right-click on the catalog to configure, or right-click on the table the FT index is on -> go into the "Full-Text index" section -> Properties)

    USE [AdventureWorks2008]

    GO

    ALTER FULLTEXT INDEX ON [Person].[Person] ADD ([MiddleName])

    GO

    SQLServerNewbieMCITP: Database Administrator SQL Server 2005

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply