Subject Re: [firebird-support] Modification of the DB structure
Author Uwe Grauer
poulposore wrote:

> Hi,
>
> I'm new to FB, and I have many questions about it (I'll ask for the
> others later ;-))
>
> As I understood, all triggers and stored procs are compiled (it's the
> one I'm wondering about at the moment):
> so, if I've got a "evoluting" DB with modification of the structure
> with time, how can I make "automatic" modifications to the customer
> structure ? I mean, if I have to change StoredProcs or add new ones
> for example, how can I declare it on my customers DB and recompile
> them by code, without having each time to give a "new" structure and
> copy the data to the one ?
>
> Thanks for informations / suggestions,
>
> David

David,

get langref.pdf from ibphoenix.com and read about sql-statement ALTER TABLE.

Uwe