sys-filetables-transact-sql.md

title	sys.filetables (Transact-SQL) | Microsoft Docs
ms.custom
ms.date	06/10/2016
ms.prod	sql
ms.prod_service	database-engine
ms.reviewer
ms.technology	system-objects
ms.topic	language-reference
f1_keywords	filetables filetables_TSQL sys.filetables sys.filetables_TSQL
dev_langs	TSQL
helpviewer_keywords	sys.filetables catalog view
ms.assetid	a740be59-cd52-4707-9ad2-5203669a63ac
author	stevestein
ms.author	sstein

sys.filetables (Transact-SQL)

[!INCLUDEtsql-appliesto-ss2012-xxxx-xxxx-xxx-md]

Returns a row for each FileTable in [!INCLUDEssCurrent]. 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

Manage FileTables
FileTables (SQL Server)