Class FilestreamAndFileTableSchema.FileTableSystemDefinedObject

Namespace

LinqToDB.Tools.DataProvider.SqlServer.Schemas

Assembly

linq2db.Tools.dll

sys.filetable_system_defined_objects (Transact-SQL)

Applies to: √ SQL Server (all supported versions)

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

See sys.filetable_system_defined_objects.

[Table(Schema = "sys", Name = "filetable_system_defined_objects", IsView = true)]
public class FilestreamAndFileTableSchema.FileTableSystemDefinedObject

Inheritance

object

FilestreamAndFileTableSchema.FileTableSystemDefinedObject

Extension Methods

Map.DeepCopy<T>(T)

Properties

Object

objects (sys.objects)

[Association(ThisKey = "ObjectID", OtherKey = "ObjectID", CanBeNull = false)]
public ObjectSchema.Object Object { get; set; }

Property Value

ObjectSchema.Object

ObjectID

Object ID of the system-defined object related to a FileTable.

References the object in sys.objects.

[Column("object_id")]
[NotNull]
public int ObjectID { get; set; }

Property Value

int

ParentObjectID

Object ID of the parent FileTable.

References the object in sys.objects.

[Column("parent_object_id")]
[NotNull]
public int ParentObjectID { get; set; }

Property Value

int