The alter script option gives more information than it should.
Steps to reproduce the problem:
1] Create a model with 2 or 3 tables (model 1)
2] Generate script to create database
3] Create database
4] Add a column to model 1
5] Reverse Engineer from the database to create a new model
6] Compare two models to create the alter script.
The only difference that Toad Data Modeler should show is the addition of the new column but the script has a lot of extra data. It is possible to ignore some of the data but not all of it.
You need to be signed in and under a current maintenance contract to view premium knowledge articles.
© ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center