Is there a table that has all the Table entries?

[Markell]

Hi Guys

Basically, I know sys_db_object has all tables and sys_dictionary has all table columns but is there A overall table that has all table entries? For example it maps the tablee, column and also the entry for that column?

Thanks in Advance

[Anurag Tripathi]

Hi,

All the dictionary are stored in sys_dictionary table

Table definitions are storied in sys_db_object only.

When  you open the table definition, you see a list of columns, that is just fetched from dictionary based on the table name mapped there.

Now what you want , probably you can just from Dictionary table , if you filter ny the tabe name, as showin the screenshot below

This way i am able to see all the fields on incident table and their types and attributes etc.

Hope this helps.

-Anurag

[Markell]

No what I'm looking for is e.g:

Table: sys_user

column Label: User

column Name: user

but then a list of all the users under user. So would be multiple entries of 'user' and a column that had either the reference to or string of the user name for that record / entry

[Riya Garg1]

sys_db_object stores all the table names.

[Saurav11]

Hello,

I do not think you can get all the information in one single view in Servicenow.

There are surely database view which we generally create to have multirole table records in one view. but I do not see any way to do it using that as well.

Please mark answer correct/helpful based on impact