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

[code lang=”sql”]

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
[/code]

Leave a Reply