sys.filetables (Transact-SQL)

THIS TOPIC APPLIES TO: yesSQL Server (starting with 2012)noAzure SQL DatabasenoAzure SQL Data Warehouse noParallel Data Warehouse

Returns a row for each FileTable in SQL Server 2017. 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)