1. Vertabelo
  2. Błędy
0
Rozpoczęte

Wrong add column command generation for Oracle databases

Mateusz Kamiński 7 lat temu • Ostatnio zmodyfikowane przez Rafał Strzaliński (Senior Engineer) 7 lat temu • 1

It looks like the term COLUMN is unnecessary in "ALTER TABLE <table_name> ADD COLUMN ..." for Oracle migration scripts and causes error when executed on a database.

Rozpoczęte
Rafał Strzaliński (Senior Engineer) 7 lat temu

Hi,


I've made a test. I've created model, added table, added collumns, and finally generated migration script. I got this query:



ALTER TABLE "Table_1"
    ADD "column_2" int  NOT NULL;


Could you send us an example model to reproduce it? Are you sure your model is an "Oracle" database model?




Customer support service by UserEcho