title: "sys.sysfulltextcatalogs (Transact-SQL) | Microsoft Docs" ms.custom: "" ms.date: "03/15/2017" ms.prod: "sql" ms.prod_service: "database-engine, pdw" ms.service: "" ms.component: "system-compatibility-views" ms.reviewer: "" ms.suite: "sql" ms.technology:
- "database-engine" ms.tgt_pltfrm: "" ms.topic: "language-reference" f1_keywords:
- "sysfulltextcatalogs"
- "sys.sysfulltextcatalogs_TSQL"
- "sysfulltextcatalogs_TSQL"
- "sys.sysfulltextcatalogs" dev_langs:
- "TSQL" helpviewer_keywords:
- "sys.sysfulltextcatalogs compatibility view"
- "sysfulltextcatalogs system table" ms.assetid: 18ac6ad5-01e8-428f-8422-a9ca29626977 caps.latest.revision: 38 author: "rothja" ms.author: "jroth" manager: "craigg" ms.workload: "Inactive" monikerRange: ">= aps-pdw-2016 || >= sql-server-2016 || = sqlallproducts-allversions"
[!INCLUDEtsql-appliesto-ss2008-xxxx-xxxx-pdw-md]
Contains information about the full-text catalogs.
Important
[!INCLUDEssnoteCompView]
| Column name | Data type | Description |
|---|---|---|
| ftcatid | smallint | Identifier of the full-text catalog. |
| name | sysname | Full-text catalog name specified by the user. |
| status | smallint | [!INCLUDEssInternalOnly] |
| path | nvarchar(260) | Root path specified by the user. NULL = Path was not specified. The default (installation) path was used. |
Mapping System Tables to System Views (Transact-SQL)
Compatibility Views (Transact-SQL)