sys.filetables (Transact-SQL)

Applies to: SQL Server

Returns a row for each FileTable in SQL Server. For more information about FileTables, see FileTables (SQL Server).

Column name	Data type	Description
object_id		Object identification number. Is unique within a database. For more information, sys.objects (Transact-SQL).
is_enabled	bit	1 = FileTable is in 'enabled' state.
directory_name	varchar(255)	Name of the root directory for a FileTable.
filename_collation_id		Is the collation identifier defined for the FileTable
filename_collation_name		Is the collation name defined for the FileTable.

See Also

Manage FileTables
FileTables (SQL Server)