Skip to main content
Is there any system tables in Celonis we can check, for example, in Oracle, we have all_objects, user_tables such kind of tables we can have an overview understanding for one DB

Hi @lingzhi.lingzhi,

 

there are some system tables that you can use in Vertica. Some examples are:

 

  • tables
  • columns

 

Are you looking for something specific?

 

Simply execute the following statement:

 

SELECT * FROM tables

 

in the Celonis EMS.

 

Hopefully, that answers your questions!

 

Best,

 

Justin


Hi @lingzhi.lingzhi,

 

there are some system tables that you can use in Vertica. Some examples are:

 

  • tables
  • columns

 

Are you looking for something specific?

 

Simply execute the following statement:

 

SELECT * FROM tables

 

in the Celonis EMS.

 

Hopefully, that answers your questions!

 

Best,

 

Justin

Thank you Justin. Yes , I can use these tables now.


Reply