Subject Alter tabel problem
Author Riho-Rene Ellermaa
I'm using FB 1.03 in Windows 2000
I have a table (containing about 20-30 records):
CREATE TABLE FOR_CORRESP (
NAME VARCHAR(35) CHARACTER SET WIN1252 NOT NULL,

ACCOUNT ACCOUNT NOT NULL,
BALCODE VARCHAR(3) CHARACTER SET WIN1252,
COUNTRY VARCHAR(3) CHARACTER SET WIN1252,
PRIMARY KEY (NAME,ACCOUNT)
);

When I tried to change it with:
alter table for_corresp alter name type varchar(70);
the ibserver.exe started to run with 90% CPU and it took 5 min to stop
the server.

Is it some server problem or shouldn't I use ALTER this way?

Riho Ellermaa