creating custom fields in the base table.

[Abhilasha G T]

Hi Team,

I want to create a some custom fields in base table for data migration activities.

suggest me the best way as per SNOW Best practices,

1. can i create a custom table by extending the base table and create a required custom fields 

                                                                    OR

2. directly can i create custom fields in the base table.

which one is correct in the above 2 points.

Regards,

Abhilasha G T

[Community Alums]

Hi @Abhilasha G T ,

If you create the custom fields directly to the base table then all the extended tables from this base table will inherit the custom fields.

So it's good to create a custom table by extending the base table and create a required custom fields.

[Harsh_Deep]

Hello @Abhilasha G T 

You can create a custom table by extending the base table and create a required custom fields.

This is the best practice.

Mark ✅ Correct if this solves your issue and also mark 👍 Helpful if you find my response worthy based on the impact.

[Dr Atul G- LNG]

Hi @Abhilasha G T 

Its Not SNOW, its SN or ServiceNow. 

1. can i create a custom table by extending the base table and create a required custom fields 

Atul: yes you can do.

                                                                    OR

2. directly can i create custom fields in the base table.

Atul: Yes, you can do.

But before you create a custom field

- Check is it required in all upcoming tables, if yes, then create on base else on extended tabel only.

Custom fields are chargeable so please refer here

https://www.servicenow.com/content/dam/servicenow-assets/public/en-us/doc-type/legal/custom-table-gu...