Generate SQL Alter Table Statements

[amcintyre@gatech.edu]

Hello,

How can one generate "ALTER TABLE" statements from either an existing ER model or an existing SQL model?
For instance, below is an existing model

snapshot_01.PNG

Next is the model after I modify it.

snapshot_02.PNG

How can I generate the Alter statements, such as the statement below? I don't want to generate statement to create the tables but rather alter the tables.

Code: Select all

ALTER TABLE animal_lover_large.owner
ADD COLUMN city_of_residence` VARCHAR(20) NULL;