Filestream and FileTable Catalog Views (Transact-SQL)

APPLIES TO: yesSQL Server (starting with 2012) noAzure SQL Database noAzure SQL Data Warehouse noParallel Data Warehouse

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 and FileTable Dynamic Management Views (Transact-SQL)
Filestream and FileTable System Stored Procedures (Transact-SQL)