sys.filetable_system_defined_objects (Transact-SQL)


Updated: June 10, 2016

THIS TOPIC APPLIES TO: yesSQL Server (starting with 2012)noAzure SQL DatabasenoAzure SQL Data Warehouse noParallel Data Warehouse

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

ColumnData typeDescription
object_idintObject ID of the system-defined object related to a FileTable.

References the object in sys.objects.
parent_object_idintObject ID of the parent FileTable.

References the object in sys.objects.

Create, Alter, and Drop FileTables
Manage FileTables

Community Additions