Tables changes as Alter

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

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

Thanks,
Guillaume
· Share on Twitter

Comments

  • 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.
    · Share on Twitter
Sign In or Register to comment.