Is it possible to change the "Extends table" setting of a table that has already been created?

KS18
Giga Guru

I have a table that was created by extending a table.
Is it possible to change the extended table to a different table?
In other words, is it possible to change the "Extends table" setting of a table that has already been created?

I don't think it is possible, but if there is a way, please let me know.

7 REPLIES 7

Hitoshi Ozawa
Giga Sage
Giga Sage

If the question is about changing the parent of a table, AFAIK, no.

It's necessary to recreate it.

Tables are defined in sys_db_object table but I don't think just changing the Extends table (column_name:super_class) is sufficient.

Hitoshi Ozawa
Giga Sage
Giga Sage

I was able to execute the script without any error but the parent table did not change.

Table information is saved in sys_db_object table and the "Extends table" was not changed. Furthermore, if I try to change the "Extends table" column, an error message "Cannot change what a table extends after it is created" is displayed.

find_real_file.png

So in all, it's no longer possible to change the parent table.

I tried to run the background script using GlideTableParentChange(), but nothing happened.
It is the same as yours.