sys.database_filestream_options

Description

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. For more information about FileTables, see The ID of the database. This value is unique within the The database-level directory for all FileTable namespaces. The level of non-transactional access to FILESTREAM data that is enabled.