Generate SQL Alter Table Statements

Discussions about database modeling product Cameo Data Modeler functionalities

Moderator: Moderators

Generate SQL Alter Table Statements

Postby » Tue Jul 05, 2022 12:44 pm


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

Next is the model after I modify it.

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.
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 0 guests