| title | description | author | ms.author | ms.date | ms.service | ms.subservice | ms.topic | f1_keywords | helpviewer_keywords | dev_langs | ||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
sys.filetable_system_defined_objects (Transact-SQL) |
sys.filetable_system_defined_objects (Transact-SQL) |
rwestMSFT |
randolphwest |
06/10/2016 |
sql |
system-objects |
reference |
|
|
|
[!INCLUDE SQL Server]
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. |