filestream-and-filetable-catalog-views-transact-sql.md

title	Filestream and FileTable Catalog Views (Transact-SQL) | Microsoft Docs
ms.custom
ms.date	03/06/2017
ms.prod	sql
ms.prod_service	database-engine
ms.reviewer
ms.technology	system-objects
ms.topic	language-reference
dev_langs	TSQL
helpviewer_keywords	FileTables [SQL Server], catalog views
ms.assetid	2c83a4a7-720b-4435-a3b5-788c29f56949
author	stevestein
ms.author	sstein

Filestream and FileTable Catalog Views (Transact-SQL)

[!INCLUDEtsql-appliesto-ss2012-xxxx-xxxx-xxx-md]

This section describes the catalog views related to the FileTable feature.

Filestream and filetable Catalog Views (Transact-SQL)

sys.database_filestream_options (Transact-SQL)
Displays information about the level of non-transactional access to FILESTREAM data in FileTables that is enabled. Contains one row for each database in the SQL Server instance.

sys.filetable_system_defined_objects (Transact-SQL)
Displays a list of the system-defined objects that are related to FileTables. Contains one row for each system-defined object.

sys.filetables (Transact-SQL)
Returns a row for each FileTable. Inherits from sys.tables.

See Also

Filestream
Filetables
Filestream and FileTable Dynamic Management Views (Transact-SQL)
Filestream and FileTable System Stored Procedures (Transact-SQL)