[firebird-support] Basic sql alter table commands

2014-02-22 Thread Jack Cane
Although longtime FB user, I'm new to the alteration process, and having difficulty finding the right sources. Would you please point me to a basic text on renaming/altering/dropping/adding columns to existing FB tables. Best, jwc

Re: [firebird-support] Basic sql alter table commands

2014-02-22 Thread Thomas Steinmaurer
Although longtime FB user, I'm new to the alteration process, and having difficulty finding the right sources. Would you please point me to a basic text on renaming/altering/dropping/adding columns to existing FB tables.

Re: [firebird-support] Basic sql alter table commands

2014-02-22 Thread Jack Cane
Immediate need is pretty simple I think: rename a column and change data type of another column. Tried a couple variants based on examples from web search, but my IB_SQL scripting tool rejected them. Thanks, jwc On Feb 22, 2014, at 2:23 PM, Jack Cane jwc...@enwphotos.com wrote: Although

Re: [firebird-support] Basic sql alter table commands

2014-02-22 Thread Jack Cane
Achieved success using examples from the Razor site. If that is the best available, I'm fine with that. Thanks anyway. Best, jwc On Feb 22, 2014, at 2:23 PM, Jack Cane jwc...@enwphotos.com wrote: Although longtime FB user, I'm new to the alteration process, and having difficulty finding the

Re: [firebird-support] Basic sql alter table commands

2014-02-22 Thread Paul Vinkenoog
Hi Jack, Achieved success using examples from the Razor site. If that is the best available, I'm fine with that. Thanks anyway. You can pick up the InterBase 6 Language Reference here: http://www.ibphoenix.com/files/60LangRef.zip, and visit the section SQL Statement and Function Reference