I implemented a model, and loaded data into the tables. Now I realise that I made a mistake in the cardinality of a tie. Instead of 1 to many, it should be a many to many tie.
I can change this easily enough in the model, by toggling the identifier. After changing the model, I generate the SQL to implement the change in the database. But the SQL for this tie-table starts with IF NOT EXISTS. So even if I execute the sql from the altered model, this change will not be implemented in the database.
Should I manually update the key-setting for this table?
Is it possible to get the tool to write SQL that will implement this kind of change?