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. |