At 09:31 AM 17/08/2004 +0200, Mr Bamsemums wrote:

>Actually, 31 characters for object names, less for constraint names.

I've heard this rumour about short contraint name limits too, but I can't
get Firebird to reject a 31-character constraint name.

Try this in your horriblest database:

create table table1 (
id integer not null primary key,
data varchar(30));
commit;
create table table2 (
id integer not null primary key,
data varchar(30),
fid integer,
constraint fk_t111111111111111111111111111 foreign key (fid)
references table1);
commit;
alter table table2
drop constraint fk_t111111111111111111111111111 ;
commit;
alter table table2
add constraint fk_t111111111111111111111111111 foreign key (fid)
references table1 ;
commit;

Not a squawk.

/heLen