We are going to see the concept of keys on Tables in Ax2012. These all following keys that we are going though appears in the AOT Table properties window. Primary Key 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. When we create a new table in AX2012 the Primary key was enforced by an index that has one field, this field should be unique, by default the primary key is based on Recid field. This is represented as surrogateKey in the table properties primary index. By default the CreateRecIdIndex property was true and ClusterIndex as surrogateKey. The ClusterIndex value is given to the underlying Microsoft SQL Server database system as a performance tuning choice. This choice generally controls the physical sequence in which the records are stored in the underlying database. ReplacementKey This key is used to define the repl...
.. Vinod Kokkirala