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

Reply via email to