As most of you may know, when you are going to add a mandatory(not null) column to an existing table, the table must be empty in order to be able to alter it.
Another Modeling tool called E/R Studio during the comparison detects if the table is empty or not, if not it renames the existing table and create a new one with the new column included and then the generated script move the data from the renamed table to the new one. When I did the compare in Toad Data modeler the result was not the same,it only gave me the alter statement. Statement that is not possible to be executed by the DBMS given that the table needs to be empty to make the alter possible. Do you know if Toad Data modeler handles in certain way this particular case or is a feature that Toad needs to include?
Message was edited by: coqui