Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Filestream and FileTable Catalog Views (Transact-SQL)
Collapse the table of content
Expand the table of content

Filestream and FileTable Catalog Views (Transact-SQL)


Applies To: SQL Server 2014, SQL Server 2016 Preview

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

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.

For more information about FileTables, see FileTables (SQL Server).

Community Additions

© 2015 Microsoft