Subject | RE: [firebird-support] Upgrade table structure |
---|---|
Author | Gustavo |
Post date | 2005-06-29T02:32:04Z |
Hello:
I agree that updating RDB$... tables may not be a good idea. But I didn't knew the DDL statement Graeme mentioned to alter a field definition.
I didn't find it in the documentation of InterBase 5 or in "Firebird_v15.108_ReleaseNotes.pdf". Perhaps I have to get documentation more up to date. By the way, can anyone tell me which is the most recent InterBase version which documentation is applicable to FireBird and which is the link to download it?
Gustavo
[Non-text portions of this message have been removed]
I agree that updating RDB$... tables may not be a good idea. But I didn't knew the DDL statement Graeme mentioned to alter a field definition.
> ALTER TABLE <TABLE> ALTER <FIELD> TYPE <NEWFIELDTYPE>Can you tell me where can I find the complete syntax for this statement?
> This is the syntax for changing a field type.
I didn't find it in the documentation of InterBase 5 or in "Firebird_v15.108_ReleaseNotes.pdf". Perhaps I have to get documentation more up to date. By the way, can anyone tell me which is the most recent InterBase version which documentation is applicable to FireBird and which is the link to download it?
Gustavo
[Non-text portions of this message have been removed]