How to query MaxDB data dictionary?

[Vitaliy-R]

I am completely new to MaxDB. What I am trying to find is what are data dictionary tables in MaxDB, for example to list tables or views. I have access to CLI, but not to Database Studio.

Where is documentation of data dictionary of MaxDB?

Thank you,

-Vitaliy

[lbreddemann · Accepted solution]

>

> I am completely new to MaxDB. What I am trying to find is what are data dictionary tables in MaxDB, for example to list tables or views. I have access to CLI, but not to Database Studio.

How about this: ["Definitions of the System Tables"|http://maxdb.sap.com/doc/7_6/9c/b33d40425326439dfc0366a8dcbf55/content.htm] ?

You really should try to get access to the database via SQL Studio, DB Studio or any other JDBC SQL query tool.

The sqlcli tool is rather... let's say basic.

> Where is documentation of data dictionary of MaxDB?

WHAT? You also don't have access to the search field in the upper right corner?

Come on!

Check [http://maxdb.sap.com/documentation] and [http://maxdb.sap.com/training] !

regards

Lars

[Vitaliy-R · Accepted solution]

Why, Lars? I found running

sql_execute SELECT * FROM SCHEMAS

pretty ... well, interesting

My bad about "system tables" - I was searching for "data dictionary" or "dictionary"...

Thank you for quick help!

-Vitaliy