Subject | Re: [ib-support] Error on dropping view. |
---|---|
Author | Milan Babuskov |
Post date | 2002-12-20T16:47:32Z |
fabiano_bonin wrote:
drop view v_t1;
HTH
Milan Babuskov.
> create table t1 (t1 is not a view, it's a table. You should try:
> a integer );
>
> insert into t1 (a) values (1);
>
> create view v_t1 as select a from t1;
>
> drop view t1;
drop view v_t1;
> error: Dynamic SQL Error. SQL Error Code = -607. Log record headerYou cannot drop the table since view is using it.
> too small at offset 469399988 in log file 8Vt
>
> drop table t1;
HTH
Milan Babuskov.