sys-sysfulltextcatalogs-transact-sql.md

title	sys.sysfulltextcatalogs (Transact-SQL) | Microsoft Docs
ms.custom
ms.date	03/15/2017
ms.prod	sql
ms.prod_service	database-engine, pdw
ms.reviewer
ms.technology	system-objects
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
author	rothja
ms.author	jroth
manager	craigg
monikerRange	>=aps-pdw-2016||>=sql-server-2016||=sqlallproducts-allversions||>=sql-server-linux-2017||=azuresqldb-mi-current

sys.sysfulltextcatalogs (Transact-SQL)

[!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.

See Also

Mapping System Tables to System Views (Transact-SQL)
Compatibility Views (Transact-SQL)