How to find the difference between custom and normal attributes in table schema.

[adigelli]

Hi Team,

I am able to get the schema of a particular table. the table contains custom attributes as well.

Can i know how to differentiate from existing and custom attributes from the schema. ( like any attribute like that).

Thanks in Advance.

[dmaze531]

I've noticed there is a Red X next to customer created fields on a table that allow one to delete the custom field. Maybe this is an attribute you can key off of?

Section 3, Step 5:

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

[Ivano B]

Hi Staging dev

Usually custom tables or custom fields can be recognised because they start with u_

For instance

• if you create a custom table named 'Fruit' the table name will be u_fruit
• If you create a custom field named 'Tech description' on an existing table (custom table or OOB table) the field's name will be u_tech_description

I hope this will help.

R0bo

[Patsy Craig]

Where and how do I see this u_?  I was told it should show up if I create a report and export the fields...that there would be a u_ in the field names.  I don't find any fields noted that way when I export. How do I get a list of fields from each table that tell me whether they are custom or not?

[adigelli]

Hi R0bo,

When i am creating custom attribute, it is starting with x. like example x_60935_auto_prov_test_duration.

Thanks.