This happens when the table name is very long. In that case Ax will append the table Id to the name in the database to ensure uniqueness of the name.
Andrew Jones a1x limited --- In [email protected], "shaakera_b" <[EMAIL PROTECTED]> wrote: > > Hi there, > > I have noticed something very strange with our SQL database. > For custom tables that we have created on the VAR layer, the table name > in SQL when viewing it, has the table ID appended to it. This is not > for all the tables, but only a select few. For some tables, there are > 2, where the first table has the actual name defined in the AOT (eg > TABLEName) and the 2nd instance of the table in the DB has the first > few characters of the name, followed by the table ID (eg tablena30068). > > I assume this has something to do with the tableID's changing between > our test and production environment. > > My question is: > 1. what causes it > 2. how to fix it > 3. avoid it in future > > Many thanks for your kind assistance and insight. > > Regards, > Shaakera >
