Events
Mar 31, 11 PM - Apr 2, 11 PM
The biggest SQL, Fabric and Power BI learning event. March 31 – April 2. Use code FABINSIDER to save $400.
Register todaysys.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. |