You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
create table SOME$TABLE (SOME$FIELD integer);
create view SOME$VIEW1(SOME$FIELD) as select T.SOME$FIELD from SOME$TABLE T;
create view SOME$VIEW2(SOME$FIELD) as select T.SOME$FIELD from SOME$VIEW1 T;
create domain D$SOME$DOMAIN as integer;
alter table SOME$TABLE alter column SOME$FIELD type D$SOME$DOMAIN;
This operation is not defined for system tables.
unsuccessful metadata update.
cannot delete.
DOMAIN RDB$XXXXX.
there are 1 dependencies.
The problem is the presence of a second view. If you remove it or remove a variable field from it, there will be no error.
Moreover, if the domain of the field (for example, initially when creating the table) is set to custom, then changing it to another is quiet.
The text was updated successfully, but these errors were encountered:
Submitted by: ABog (abog)
create table SOME$TABLE (SOME$FIELD integer);
create view SOME$VIEW1(SOME$FIELD) as select T.SOME$FIELD from SOME$TABLE T;
create view SOME$VIEW2(SOME$FIELD) as select T.SOME$FIELD from SOME$VIEW1 T;
create domain D$SOME$DOMAIN as integer;
alter table SOME$TABLE alter column SOME$FIELD type D$SOME$DOMAIN;
This operation is not defined for system tables.
unsuccessful metadata update.
cannot delete.
DOMAIN RDB$XXXXX.
there are 1 dependencies.
The problem is the presence of a second view. If you remove it or remove a variable field from it, there will be no error.
Moreover, if the domain of the field (for example, initially when creating the table) is set to custom, then changing it to another is quiet.
The text was updated successfully, but these errors were encountered: