cancel
Showing results for 
Search instead for 
Did you mean: 

maxdb system tables for sysdd

0 Kudos

Hi, experts.

I am wondering if there is any documentation on maxdb system tables used internally. I've read "Definitions of the System Tables" and found out that most of the tables are "VIEWS" made from tables in sysdd schema.

And there is no documentation on sysdd schema.

I'd like to see a list of all system tables used by maxdb internally.

So could you help me to find those documents?

Thank you for your help in advance.

Accepted Solutions (1)

Accepted Solutions (1)

0 Kudos

Hi, user.

The internal system tables sysdd.* are not documented, because they are internal

We enjoy the freedom to change, rename, add or remove these tables at will.

For a complete list of systemtables you can look at the 'const' section in vak41

http://dev.mysql.com/get/Downloads/MaxDB/7.6.00/maxdb-source-7_6_00_37.tgz/from/pick#mirrors

http://www.google.com/codesearch?hl=en&lr=&q=CONST+file%3Avak41&btnG=Search

but please don't rely on the existance of these tables.

Henrik

0 Kudos

Hi, Henrik.

Thank you very much for your help.

I have not read through all, however, I'm sure it would be very helpful to me.

It might solve the curiosity I have.

Thank you.

TTK
Employee
Employee
0 Kudos

Hello

FYI, you can use JDBC or ODBC to get meta information from the DB. Both interfaces provide standard techniques to query the DB for catalog information.

Regards Thomas

Answers (0)