March 3, 2008 at 3:02 pm
Gents and ladies,
I am generating an alter script using ERwin for SQL server 2005. But it's generating individual ADD COLUMN statements for each column I added to model. For example, if I add 5 columns to a table, it generates 5 individual alter table statements.
Does anyone know how to configure ERWIN to generate single alter statement?
Appreciate your responses.
thanks
M.
March 9, 2008 at 10:26 am
Hi,
I tried a lo to get this but i couldn't find option in ERWin. Please let me know if you find one.
thanks -- Vj
March 13, 2008 at 9:30 am
Hi:
This doesn't make sense, but I was able to do this recently. When you generate the Alter Script in ERwin, try checking the "Physical Storage" checkbox option (in the Options tab, under Table). I tried that, and the ADD statements disappeared and were replaced with ALTER table xxx, ADD Column xxx.
July 22, 2017 at 5:38 am
This was removed by the editor as SPAM
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply