Hoping I can create a SQL file adding a new column to an existing table.
In the SQL file:
ALTER TABLE table name ADD column name VARCHAR(10);
ALTER TABLE table name ADD (column name VARCHAR(10));
While in the model, used the Import File option then selected the SQL file and executed it.
Is this even possible? I have been successful creating tables using this method but having problems altering tables.
Any help would be appreciated
could you please explain what exactly needs to be done. Provided you have your model (i.e. reverse-engineered one) and see your table within a physical model. If so, why don't you just add the new column to the table and generate the new script? In case of working directly on actual DB while using the admin tool (like PgAdmin for postgresql, in example) you may want to look in here:
Powered by IDERA