How to change field types or field length comfortably in Firebird?

Question

I mean, even if the database is empty, you have to drop a varchar(50) field and recreate it to make it varchar(30). Not to mention constraints... This is very frustrating. I am the SYSDBA and Firebird make very simple things way harder than it should be. If I voluntarily decide to shoot my own feet, then by all means, let me do so! So how do you do structure changes comfortably in Firebird?

Accepted Answer

You can't in Firebird.

I advice you to use DOMAIN and smaller size of varchar. If you need to increase the size field : it will be easier.

For your change, you can see here

Why you have this need ?

How to change field types or field length comfortably in Firebird?

Solution

Problem