Microsoft SQL server 2005:SQL Script to check if an object contains fulltext index specified

Microsoft SQL server 2005:SQL Script to check if an object contains fulltext index specified

IF EXISTS( SELECT * FROM sys.objects o INNER JOIN sys.fulltext_indexes fti ON o.object_id=fti.object_id WHERE o.name=’Your table or view name’ ) BEGIN –Your Code Here END