sys.filetables (Transact-SQL)


Updated: June 10, 2016

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 2016. For more information about FileTables, see FileTables (SQL Server).

Column nameData typeDescription
object_idObject identification number. Is unique within a database.

For more information, sys.objects (Transact-SQL).
is_enabledbit1 = FileTable is in 'enabled' state.
directory_namevarchar(255)Name of the root directory for a FileTable.
filename_collation_idIs the collation identifier defined for the FileTable
filename_collation_nameIs the collation name defined for the FileTable.

Manage FileTables
FileTables (SQL Server)

Community Additions