This discussion is archived
3 Replies Latest reply: Sep 26, 2013 11:39 PM by user13430807 RSS

How to alter a model?

ceving Newbie
Currently Being Moderated

I have a logical and a relational model and a running database created by the DDL generated from the relational model. Now I need to modify the logical model in that way that I have to add a "NOT NULL" attribute to an entity. What is the best practice to get the changes into the database?

 

As far as I can see the DDL creation creates only "create" statements. So the first question is: how can I create "alter" statements?

 

And the second question is: how do I get the data into the database during the alter statement? The data is necessary to satisfy the constrain of the new column. This means I have to merge the alter statements with the data insertion in one transaction. How to get this done?

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points