Generate SQL Alter Table Statements

Discussions about database modeling product Cameo Data Modeler functionalities

Moderator: Moderators

Generate SQL Alter Table Statements

Postby amcintyre@gatech.edu » Tue Jul 05, 2022 12:44 pm

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;
You do not have the required permissions to view the files attached to this post.
amcintyre@gatech.edu
Forum Newbie
Forum Newbie
 
Posts: 1
Posts Rating:0
Joined: Fri May 27, 2022 4:34 pm

Return to Cameo Data Modeler

Who is online

Users browsing this forum: No registered users and 1 guest

cron