Export (0) Print
Expand All

sys.filetables (Transact-SQL)

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

Applies to: SQL Server (SQL Server 2012 through current version).

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.

Community Additions

ADD
Show:
© 2014 Microsoft