![]() ![]() ![]() The replacement key is chosen by setting the ReplacementKey property on the table. Each table can have a maximum of one replacement key. ReplacementKeyĪ replacement key is an alternate key that the system can display on forms instead of a meaningless numeric primary key value. The properties of the AtomStIdx alternate key and indexįor more information about the properties of table relations, see Table Relation Properties. The previous AtomStFkyRel relation references this alternate key. The following image displays the AtomStIdx alternate key on the AtomicState table. The properties for the AtomStFkyRel relation The foreign key is comprised of the AtomicStateName field. The following image shows that the AtomStIdx alternate key of the AtomicState parent table is referenced by this foreign key of the AtomicElement child table. In Microsoft Dynamics AX a relation represents a foreign key. The properties of the SymIdx index Relation The following image shows that the SymIdx index is an alternate key. The ValidTimeStateKey property cannot be set to Yes when the AlternateKey property is set to No. Yes means this key contains the ValidFrom and ValidTo fields. This field can be Yes only if the ValidTimeStateFieldType property is Yes on the table. Instead, this key is meant for managing date effective data in its own table. Indexes with two or more fields cannot have their AlternateKey property value set to Yes.Ī key that is marked as a valid time state key is not a candidate key for child tables to reference in their foreign key relations. Yes means that other tables can create foreign key relations that reference this key, as an alternative to referencing the primary key. No means that the combined fields of the index must together make a value in each record which no other record has. The following table describes properties on the AOT node for an index. The AlternateKey property must be set to Yes to make a unique index be an alternate key. However, a unique index alone does not make an alternate key. In practice each alternate key relies on a unique index for its implementation and enforcement. As an option, an alternate key can be chosen as the ReplacementKey of a table. However, it is more common for a table to reference the primary key of another table. Any one alternate key can switch to being the primary key, if the alternate key is comprised of only one field.Ī table can reference the alternate key of another table. Properties of the AtomicElement demonstration table Alternate KeyĪ table can have several alternate keys. The following AOT image highlights the table properties that are related to keys. This choice generally controls the physical sequence in which the records are stored in the underlying database. The ClusterIndex value is given to the underlying Microsoft SQL Server database system as a performance tuning choice. The ReplacementKey should be a set of fields that represent the natural key. If a ReplacementKey is chosen, its fields can appear on forms to helpfully identify each record. You might change the default blank value to an index whose field values within each record provide a name or other moniker that is meaningful to people. The drop-down list contains every index that has its AlternateKey property set to Yes. No other field is added to this index, not even DataAreaId. This property controls whether the system creates a unique index on the RecId field. Songkong replace artist when never replace chosen plus#The drop-down list contains the surrogate key plus every index on the table that has its AlternateKey property set to Yes. The following table describes the PrimaryIndex property and other major properties that are related to keys. This is represented as the surrogate key in the user interface. For new tables the default is a primary key based on the RecId field. The one field is usually an incremented number or a completely meaningless number that is generated by the system. Starting in Microsoft Dynamics AX 2012 the primary key for every new table is always enforced by an index that has exactly one field. The primary key is usually the type of key that other tables, called child tables, refer to when a foreign key field in those other tables need a relational identifier. ![]() There is a maximum of one primary key per table, whereas a table can have several alternate keys. The other type of key is an alternate key. Primary KeyĪ primary key is one type of key. This section describes the terminology for keys that appear in property names in the AOT Properties window. This topic describes several terms and concepts of keys on data tables, as they apply to Microsoft Dynamics AX.Īll keys are unique keys, meaning they disallow duplicate values and null values. Applies To: Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2, Microsoft Dynamics AX 2012 Feature Pack, Microsoft Dynamics AX 2012 ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |