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

[shloke04 · Accepted solution]

Hi,

Navigate to this module which gives you the info you need in a Single Page view itself:

Module Name: Tables & Columns

So in this view you can view both Table name and their Dictionary as well

Apart from this the  table which holds Table details are "sys_db_object" which is nothing but the Table Module which you have already mentioned in your question itself.

Hope this helps. Please mark the answer as correct/helpful based on impact.

Regards,
Shloke

[shloke04]

Hi @Markell 

Also to add an additional info along with what I have shared above is there is another Table Name as "sys_storage_table_alias" similar to Dictionary alias which holds alias name for each Table as shown below:

 

Hope this helps. Please mark the answer as correct/helpful based on impact.

Regards,
Shloke