sys-filetable-system-defined-objects-transact-sql.md

title	sys.filetable_system_defined_objects (Transact-SQL) | Microsoft Docs
ms.custom
ms.date	06/10/2016
ms.prod	sql-non-specified
ms.reviewer
ms.suite
ms.technology	database-engine
ms.tgt_pltfrm
ms.topic	language-reference
f1_keywords	sys.filetable_system_defined_objects_TSQL filetable_system_defined_objects filetable_system_defined_objects_TSQL sys.filetable_system_defined_objects
dev_langs	TSQL
helpviewer_keywords	sys.filetable_system_defined_objects catalog view
ms.assetid	62022e6b-46f6-495f-b14b-53f41e040361
caps.latest.revision	9
author	BYHAM
ms.author	rickbyh
manager	jhubbard

sys.filetable_system_defined_objects (Transact-SQL)

[!INCLUDEtsql-appliesto-ss2012-xxxx-xxxx-xxx_md]

Displays a list of the system-defined objects that are related to FileTables. Contains one row for each system-defined object.

When you create a FileTable, related objects such as constraints and indexes are created at the same time. You cannot alter or drop these objects; they disappear only when the FileTable itself is dropped.

For more information about FileTables, see FileTables (SQL Server).

Column	Data type	Description
object_id	int	Object ID of the system-defined object related to a FileTable. References the object in sys.objects.
parent_object_id	int	Object ID of the parent FileTable. References the object in sys.objects.

See Also

Create, Alter, and Drop FileTables
Manage FileTables