How to check the tables in Database

[Former Member]

Hi,

I could logged into the SAPDB database using the command

dbmcli -d VAN -u control,control

Now i want to list all the tables form the database VAN

how should i do it

[Former Member]

Hello,

you can logon as SYSDBA User to the SQLStudio eg. as SUPERDBA and use the system table domain.tables where all tables,views synonyms etc are listed.

In DBMCLI you have to open an SQL-Session to start any sql command:

e.g. sql_connect <sysdba>, <password>

sql_execute select tablename from domain.tables where type = 'TABLE' to list all

tablenames in you database.

Regards, Christiane

[Former Member]

Thanks Christiane ,

the answer was very helpful.

One more help required.

How to check all the database users in the J2E database.

What is the mysql query for this

[Former Member]

Hi,

All Users are stored in the system table USERS; you can start the SELECT * from USERS to find out which users are created in your MaxDB J2E database.

Regards, Christiane