• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 388
  • Last Modified:

FULLTEXT INDEX

Stupid question, but how can I tell if a FULLTEXT INDEX exists on a table?
0
MariaHalt
Asked:
MariaHalt
  • 2
1 Solution
 
Daniel_PLDB Expert/ArchitectCommented:
USE <your db name>
SELECT * FROM sys.fulltext_indexes
0
 
Daniel_PLDB Expert/ArchitectCommented:
Oh, you wanted table name, sorry:


SELECT t.name AS TableName, c.name AS FTCatalogName, OBJECT_NAME(i.object_id), i.is_enabled
FROM sys.tables t JOIN sys.fulltext_indexes i
  ON t.object_id = i.object_id
JOIN sys.fulltext_catalogs c
  ON i.fulltext_catalog_id = c.fulltext_catalog_id

Open in new window

0
 
MariaHaltAuthor Commented:
Perfect!  Thanks.
0

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now