sys-sysfulltextcatalogs-transact-sql.md

title	sys.sysfulltextcatalogs (Transact-SQL) | Microsoft Docs
ms.custom
ms.date	03/15/2017
ms.prod	sql-non-specified
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	BYHAM
ms.author	rickbyh
manager	jhubbard
ms.workload	Inactive

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)