FILESTREAM and FileTable catalog views (Transact-SQL)
Applies to: 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.
-
Returns a row for each FileTable. Inherits from
sys.tables
.
Related content
Feedback
https://aka.ms/ContentUserFeedback.
Coming soon: Throughout 2024 we will be phasing out GitHub Issues as the feedback mechanism for content and replacing it with a new feedback system. For more information see:Submit and view feedback for