Extend Custom tables

[tj2]

Hello,

I have a custom table ,i am not able to extend it and create another custom table.
Example - I have existing table say u_temp1 i need to create u_temp2 by extending u_temp1,(so u_temp1 is base table and u_temp2 is child table) can you please advice how can i achieve this?

Thanks

[john_lamberta]

Here is a wiki article explaining how to do it (although it looks like this functionality will be deprecated with Calgary)
http://wiki.servicenow.com/index.php?title=Creating_a_Custom_Table#Legacy_Extending_a_Table

To extend a table that is not already extended (Berlin release):

Add the property glide.table.allow_new_extension with a value of true.
Navigate to System Definition > Tables & Columns.
Select the table that you want to extend and click the Allow Extension button.
The table is now available in the Extends base table field.

Note:
You cannot extend system tables (such as sys_audit) or database view tables.
For versions prior to the Berlin release, contact Technical Support to extend a table that is not already extended.

- John

[Desmo]

Hi.

Hope I am not confusing the topic.

I created a custom table, but forgot to select another table from "Extends base table". Will adding the "Allow Extension" button enable me to do so?

FYI - I performed the steps to add the "Allow Extension" button, but the button does not appear / not visible.

Looking forward to some replies. BTW - Using Berlin release.

Thanks,
Charlie

[CapaJC]

And then with the Calgary release, table creation is getting improved:
http://wiki.servicenow.com/index.php?title=Creating_a_Custom_Table#Creating_Tables

[ganeshexpert]

Hi John,

I like you solution.

Is using 'glide.table.allow_new_extension' system property affect the system?

Regards,

Ganesh