CDT and database

Question

Hi All,

We are using MariaDB. Is it mandatory to provide after keyword in alter table query while adding new column? We are moving from lower environment to higher environment. In lower environment, the columns are in a certain order and in higher environment, we are trying to add the columns in the last and not in the same way as lower environment.

Eg: In lower env, table is like firstname, middlename, lastname. In higher environment, it will be like middlename, firstname, lastname. But both environment CDTs will be like firstname, middlename, lastname.

Will these cause any issues??

dineshd0003 · Answer

Hi Sarath,To answer your first question its not mandatory to give First/After  Keyword unless you want to add the columns in particular order.For Publishing your datastore the order of the columns doesn't matter where as only the column definitions should match with your CDT XSD Definition.Hope this answers your question.

Sign up

Login with SSO

Login to the community

Login with SSO