Delete unneeded parent table columns

[Marcel H_]

I know that I've read elsewhere that deleting parent table columns is not something that should be done, but wanted to ask the question again in the way that I'm thinking to see if someone can explain what pitfalls or trouble can be caused system wide by doing so.

Let's say that I have a table that I want to extend that meets most of my needs as far as columns, etc. and I don't want to spend the time creating a whole new table structure, since it could be time consuming. Once I extend the table, is there a way to remove the parent table's columns that I don't need at all from the child table, or does this delete it from all associated tables? I know typically you could just hide those fields on the form so they are effectively not used, but they are still there and visible when configuring things like reports. Currently if I want to create a new field on the child table with a different reference (e.g. Company referencing records on a different table than core_company for example) but keep the same label, it'll show things like "Company(company)", which as we allow more groups beyond IT staff familiar with the structure of the database (aka: Me) it could be confusing to get the right company field on your report.

If the answer if just dictionary overrides, that's great, but I'm not sure that I see a way to repoint to a different reference table, vs just using different reference qualifier conditions to effectively filter what is displayed.

Anyway, any info and guidance that anyone can provide is much appreciated. Thanks!

[SanjivMeher]

Instead of deleting you can write an ACL on that field for that particular child table you dont want to display.

[Jon Barnes · Accepted solution]

You can't delete the fields from only your table, it will delete them from the root table itself, which will affect all tables that extend that root table.

[MD MUSTAKIM]

hi Jon Barnes

if the table will effect then how can we retrieve that table...??

[Shishir Srivast]

Hi Marcel,

When you create a new custom table, several fields appear in the Table Columns embedded list. For all tables, required system fields are added automatically. You cannot delete or modify these fields.

For tables that extend another table, fields on the parent table also appear on the Table Columns embedded list for the current table. If you modify these fields, remember that all changes to fields on the parent table also affect all child tables, not just the current table.

http://wiki.servicenow.com/index.php?title=Creating_a_Custom_Table#gsc.tab=0

Hope you find this informative.