Hi here is my situation.
We are using liquibase as our automated deploy for ddl’s.
Day1 - A development team asks for a new table to be created.
Day2 - Data Architect creates it and reviews and sends the ddl to be implemented.
Day3 - Application team adds the ddl to their code and it adds to the changeset and appends into the sql file.
Day4 - Some modifications are needed like column name changes, datatype changes, lengths or dates vs timestamps. They are made in the data model and sent as a new ddl with create steps to the developer.
Day5 - Development team asks for alters instead of new create DDL’s.
So instead of having so many changes in the initial ddl create, can there be a way to over ride the ddl created on Day1 and repoint to Day5 as the base code?
If so please let me know how to do that. I don’t know all the api’s so am learning with this as well.