At 11:25 AM 20-06-01 +0200, Bernhard wrote:

>Can you tell me something about the ALTER TABLE ... CHANGE CLOUMN statement? I tseems to me this dies not exists in Interbase. Is it right?

In Firebird and InterBase 6:

Syntax
ALTER TABLE table_name ALTER [COLUMN] column_name
TYPE new_col_datatype

**or**

ALTER TABLE table_name ALTER [COLUMN] column_name
POSITION new_col_position

Not available in lower versions of InterBase though.

Cheers,
Helen


All for Open and Open for All
InterBase Developer Initiative · http://www.interbase2000.org
_______________________________________________________