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
Powered by IDERA