DB Schema: Which table contains the localized mapping?

Get Help
1

Which table in the database contains the information on the label and if the field is shown?

Example to see all of the following:

  1. How “collectionOjbectAttribute.number5” is labeled and shown.
  2. How “collectionObjectProperties.text16” is labeled and shown.

It was suggested to me that peeking at this table in MySQL workbench might be a faster way to see this information vs opening up the schema and looking around there.

2

Information is stored in tree tables: splocalecontainer (for tables), splocalecontaineritem (for fields) and splocaleitemstr (stores strings for tables and fields).

Next Specify 7 release would have a Schema Editor, so you won’t have to make these changes though the database

1 Like