Обсуждение: conditional alter table add ?

Поиск
Список
Период
Сортировка

conditional alter table add ?

От
Lothar Behrens
Дата:
Hi,

I do convert an UML XMI model to a database script to create the
database schema.
To enable multiple iterations I need conditional alter table add
column like syntax.

Is there any way to do this ?

Tanks, Lothar


Re: conditional alter table add ?

От
"Peter Childs"
Дата:


On 17/10/2007, Lothar Behrens <lothar.behrens@lollisoft.de> wrote:
Hi,

I do convert an UML XMI model to a database script to create the
database schema.
To enable multiple iterations I need conditional alter table add
column like syntax.

Is there any way to do this ?


Not easily in a straight forward sql script. your going to need to write your script in a scripting language (like perl, python or ruby) then do the alter table query dependent
on other queries to the database,

Peter.