Alter Table - Add Column by Importing SQL file

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);

Also tried:

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 Slight smile

Parents Reply Children
No Data