I would like to Known how to include a new column into a table using the "ERWIN modellation Suite."
I have my model running at SQL 2000 and I use ERWIN to modelate and generate the scripts, but ERWIN is not "ON-LINE" with my model.
Let say, I do everything using ERWIN, I "preview" the scripts and then I run them into the query analyzer.
If I want to include a column, the erwin script Drop the table, Create the table, ....
Does not exist an "Alter Table" script?? Is it necessary to drop table, FK....only to include a new column.
I must be doing something wrong?? Could some one show me the right way
Thanks A lot