Subject Re: [ib-support] Error on dropping view.
Author Milan Babuskov
fabiano_bonin wrote:
> create table t1 (
> a integer );
>
> insert into t1 (a) values (1);
>
> create view v_t1 as select a from t1;
>
> drop view t1;

t1 is not a view, it's a table. You should try:
drop view v_t1;

> error: Dynamic SQL Error. SQL Error Code = -607. Log record header
> too small at offset 469399988 in log file 8Vt
>
> drop table t1;

You cannot drop the table since view is using it.

HTH

Milan Babuskov.