sys.fulltext_index_catalog_usages (Transact-SQL)

THIS TOPIC APPLIES TO:yesSQL Server (starting with 2008)yesAzure SQL DatabasenoAzure SQL Data Warehouse noParallel Data Warehouse

Returns a row for each full-text catalog to full-text index reference.

Column name Data type Description
object_id int ID of the full-text indexed table. Is unique within the database.
index_id int ID of full-text index.
fulltext_catalog_id int ID of full-text catalog.

Permissions

The visibility of the metadata in catalog views is limited to securables that a user either owns or on which the user has been granted some permission.

See Also

Catalog Views (Transact-SQL)
Data Spaces (Transact-SQL)