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

title	FILESTREAM and FileTable Catalog Views (Transact-SQL)
description	FILESTREAM and FileTable Catalog Views (Transact-SQL)
author	rwestMSFT
ms.author	randolphwest
ms.date	10/02/2023
ms.service	sql
ms.subservice	system-objects
ms.topic	reference
helpviewer_keywords	FileTables [SQL Server], catalog views
dev_langs	TSQL

FILESTREAM and FileTable catalog views (Transact-SQL)

[!INCLUDE SQL Server]

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

FILESTREAM and FileTable catalog views

• 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.

Related content

• FILESTREAM (SQL Server)
• FileTables (SQL Server)
• FILESTREAM and FileTable Dynamic Management Views (Transact-SQL)
• FILESTREAM and FileTable system stored procedures (Transact-SQL)