show tables / describe table

[MaxDB SAP]

Hi List,

I am new to MAXDB and want to know is there any function in MAXDB like
MySQL to show all tables in a database and describe table in a
database.

Mysql> show tables;
Mysql> describe table.

Thanks in Advance.
MAXDB PHP

[Jean-Michel OLTRA]

bonjour,


Le mardi 08 février 2005, MaxDB SAP a écrit...

Post by MaxDB SAP
Mysql> show tables;
Mysql> describe table.

Use ireport, nice tool indeed.

ireport -d database -u user,passwd

then enter the `help` command, and you will see available commands
try `help table`, `table`, `table pattern` (pattern := pattern%), or
`table ATABLE`

[Jean-Michel OLTRA]

bonjour,


Le mardi 08 février 2005, Jean-Michel OLTRA a écrit...

Post by Jean-Michel OLTRA
Use ireport, nice tool indeed.

Oops, `ireport` is an alias of mine. Sorry.

Use <depend path>/bin/ireport.py

[MaxDB SAP]

Thanks friends.



On Tue, 8 Feb 2005 17:44:30 +0100, Jean-Michel OLTRA

Post by Jean-Michel OLTRA
bonjour,
Le mardi 08 février 2005, Jean-Michel OLTRA a écrit...

Post by Jean-Michel OLTRA
Use ireport, nice tool indeed.

Oops, `ireport` is an alias of mine. Sorry.
Use <depend path>/bin/ireport.py
--
jm
--
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb

[Dusan Kolesar]

Hello,
Try next (use SQL studio):
SELECT * FROM DOMAIN.TABLES WHERE TYPE = 'TABLE'
//
SELECT * FROM DOMAIN.COLUMNS WHERE TABLETYPE = 'TABLE'

The results are similar to MySql show and describe statements.

Dusan

Post by MaxDB SAP
Hi List,
I am new to MAXDB and want to know is there any function in MAXDB like
MySQL to show all tables in a database and describe table in a
database.
Mysql> show tables;
Mysql> describe table.
Thanks in Advance.
MAXDB PHP

--
Dusan Kolesar
Helsinska 19
040 13 Kosice
Slovakia
e-mail : ***@centrum.sk
ICQ# : 160507424