Alter Table...usign ERWIN tool

Last Post 31 May 2002 01:32 PM by Gordowey. 0 Replies.
AddThis - Bookmarking and Sharing Button Printer Friendly
  •  
  •  
  •  
  •  
  •  
Sort:
PrevPrev NextNext
You are not authorized to post a reply.
Author Messages
Gordowey
New Member
New Member

--
31 May 2002 01:32 PM
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

Alberto
You are not authorized to post a reply.

Acceptable Use Policy