Join the #BuildWithBuildAgent Challenge! Get recognized, earn exclusive swag, and inspire the ServiceNow Community with what you can build using Build Agent.  Join the Challenge.

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.