Differentiate which tables are configurational tables and which tables are transactional/data tables

Maradani Revat1
Tera Contributor

‎08-03-2022 04:21 AM

Hi,

We have a requirement to check which all tables are configurational tables and which are transactional/data tables. Can you please suggest how we can differentiate the table as configuration and transaction table.

 

For example - incident table is a transaction table.

user table is a configurational table

 

Like below example we need to differentiate the tables.

0 Helpfuls
  • 502 Views
1 REPLY 1

AG20
Tera Contributor

‎08-15-2022 07:55 PM

Hi Revathi,

Technically sys_user table also contains data (User data), so depends what you call a "configurational" table.

What I can suggest is, what you refer to as a "data" table is one which extends from the task table.

So you can go to /sys_db_object_list.do?sysparm_query=super_class%3DNULL&sysparm_view=

This URL will give you all tables which do no extend from any other table, which also includes sys_user.

Can these be termed as a configurational table for you?

Please mark helpful if this helps!

AG

 

0 Helpfuls