Subject | Re: [firebird-support] Modification of the DB structure |
---|---|
Author | Uwe Grauer |
Post date | 2004-02-10T17:58:05Z |
poulposore wrote:
get langref.pdf from ibphoenix.com and read about sql-statement ALTER TABLE.
Uwe
> Hi,David,
>
> 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
get langref.pdf from ibphoenix.com and read about sql-statement ALTER TABLE.
Uwe