Is it possible to change the "Extends table" setting of a table that has already been created?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎01-06-2022 02:14 AM
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.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎01-06-2022 03:09 AM
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.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎01-06-2022 03:13 AM
I haven't used it but it seems possible using GlideTableParentChange().
https://snowunderground.com/blog/category/undocumented

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎01-06-2022 03:48 PM
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.
So in all, it's no longer possible to change the parent table.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎01-06-2022 05:12 PM
I tried to run the background script using GlideTableParentChange(), but nothing happened.
It is the same as yours.