difference between Base Table and Core table

[arpitt]

What is the difference between Base Table and Core table ?

[india]

Hi, David

Root table means ..Over which your application is built.

If you are using self service application..than your core table will be sys_app_application 😉

Hope this solve your issue

Regards'

Kirtesh

[haseena ayesha]

Hi

Arpit

Please go through the below link:

https://YOURINSTANCE.service-now.com/sys_db_object_list.do?sysparm_query=super_class%3DNULL

True base tables are those that can be extended so you may want to filter on the "Extensible" field where value is true.

Thanks&Regards

Haseena.

                                                                                                    PS: Hit like, Helpful or Correct depending on the impact of the response

[Dave Smith1]

haseena ayesha wrote:

True base tables are those that can be extended so you may want to filter on the "Extensible" field where value is true.

I'm not convinced of that criteria... there are many tables that can be extended, but that doesn't make them base tables.

Similarly, I can create u_base that doesn't extend anything then mark it not extensible - it will still be a base table but not show up in your filter.

[YRK]

Hi All,

I am using Eureka version, I have not seen a table with the name "cmdb" in my instacne but in Geneva, I find there is a table with name "cmdb" (Base configuration item).

could you please help me with our answers for below listed queries.

1. Does base tables are version specific?

2. if we upgrade our instance to Helsinki, what change i can observe in my instance?

3. what about the data in the other CMDB tables if I upgrade my instance?

Configuration item table is the base table in my Eureka instance (It is not extended from the any table)

[Dave Smith1]

1. Does base tables are version specific?

Yes. I believe before Geneva, it was [cmdb_ci]

2. if we upgrade our instance to Helsinki, what change i can observe in my instance?

Check the release notes: Upgrade to Helsinki - these should have details about new features to expect.

Note: there's another post here referring to upgrade experiences:   Helsinki Upgrade (Lessons Learned)

3. what about the data in the other CMDB tables if I upgrade my instance?

Data is generally untouched during an upgrade; the change in family is rather like trying to redecorate your house whilst you are still sitting in it - your furniture and belongings should be left unaffected.

However, if you want to test it, consider getting a clone of your instance then performing an upgrade against that to dry-run the upgrade process. I would advise creating a test plan before starting so that you have identified some areas to check and test post-upgrade.