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