Post reply

reg. Full-text index

  • January 18, 2006 at 12:33 am

    #166569

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

  • January 18, 2006 at 4:24 am

    #615422

    Hi murali

    you can use 'sp_helpindex objectname'  to know the what index is created on table

     

    --sridhar

     

  • January 18, 2006 at 4:29 am

    #615425

    Hi murali

    you can use 'sp_helpindex objectname'  to know the what index is created on table

    same way you can use EXEC sp_help_fulltext_columns Objectname

    to know full text columns

     

     

    --sridhar babu tella

     

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

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