Toad World® Forums

Change script does not respect Generate property


I have two projects (TXP files) with two database versions. First version contains table ticket.receipt. But this table is mark as Generate to FALSE. So in this version of the database, this table was not generated. It simply does not exist in the database.

In the second (newer) version, I activated the Generate property to TRUE. I generated a change script, but it didn't add the table. The program recognizes that Generate was set to TRUE in the previous version, but behaves as if the table existed. It only adds columns, not the whole table.

It is bad. The change script must add the entire table because it does not exist.