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??
Discussion posts and replies are publicly visible
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.
Thanks dineshthat helps