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 :: ALTER TABLE". That's the basis.

The document Thomas pointed you to contains the updates since Firebird was 
forked from the IB sources.


Good luck,
Paul Vinkenoog

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  wrote:

> 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 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  wrote:

> 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.

http://www.firebirdsql.org/file/documentation/reference_manuals/reference_material/html/langrefupd25-ddl-table.html


-- 
With regards,
Thomas Steinmaurer
http://www.upscene.com/

Professional Tools and Services for Firebird
FB TraceManager, IB LogManager, Database Health Check, Tuning etc.

[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