Table 2000000300 Database Index

System, System.Diagnostics

Fields 24 in 29

1TableIdIntegernew in 28
2Index NameText[128]new in 28
3Company NameText[30]new in 28
4Source App IDGuidnew in 28
5Column NamesText[2048]new in 28
6Included FieldsText[2048]new in 28
7EnabledBooleannew in 28
8Metadata DefinedBooleannew in 28
9UniqueBooleannew in 28

All 24 fields

Trigger events 10

OnBeforeInsertEvent(var Rec: Record "Database Index"; RunTrigger: Boolean)
OnAfterInsertEvent(var Rec: Record "Database Index"; RunTrigger: Boolean)
OnBeforeModifyEvent(var Rec: Record "Database Index"; var xRec: Record "Database Index"; RunTrigger: Boolean)
OnAfterModifyEvent(var Rec: Record "Database Index"; var xRec: Record "Database Index"; RunTrigger: Boolean)
OnBeforeDeleteEvent(var Rec: Record "Database Index"; RunTrigger: Boolean)
OnAfterDeleteEvent(var Rec: Record "Database Index"; RunTrigger: Boolean)
OnBeforeRenameEvent(var Rec: Record "Database Index"; var xRec: Record "Database Index"; RunTrigger: Boolean)
OnAfterRenameEvent(var Rec: Record "Database Index"; var xRec: Record "Database Index"; RunTrigger: Boolean)
OnBeforeValidateEvent(var Rec: Record "Database Index"; var xRec: Record "Database Index"; CurrFieldNo: Integer)
per field, ElementName: field name
OnAfterValidateEvent(var Rec: Record "Database Index"; var xRec: Record "Database Index"; CurrFieldNo: Integer)
per field, ElementName: field name

Changes 3 in 29

List17181920212223242526272829
Fields2
Keys1
field(23; "On Main Table"; Boolean)new in 29
added
field(24; "Index Type"; Option)new in 29
added
key(PK; TableId, "Index Name", "Company Name", "Source App ID", "Index Type") { Clustered = true; }new in 28changed in 29
changed, was key(PK; TableId, "Index Name", "Company Name", "Source App ID") { Clustered = true; }

All 3 changes in 28-29