sys.filetables (Transact-SQL)

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

Concepts

Manage FileTables

FileTables (SQL Server)