What are the challenges you face when working across database platforms? Take the survey

Tables changes as Alter

gjobingjobin Posts: 5
edited April 1, 2014 11:39AM in Source Control for Oracle

Is it possible to have the tables changes checked-in as "ALTER TABLE" in the same script instead of a complete "CREATE TABLE".



  • Options
    Brian DonahueBrian Donahue Posts: 6,590 Bronze 1
    Hello Guillaume,

    Source Control's function is to create a representation of all of the objects in a schema as a series of scripts - so they will always be CREATE statements. If you need to make a synchronization script that alters objects, you can use Schema Compare for Oracle to compare the folder of CREATE scripts to a database or another folder and go through the synchronization wizard to make the script.

    Hope this helps.
Sign In or Register to comment.