Re: Hi

jean-michel OLTRA <[email protected]> Wed, 10 Sep 2003 11:28:48 +0200

Newsgroups	gmane.comp.db.sapdb.general
Message-ID	<20030910092848.GA19186@espinasse>

Le mercredi 10 septembre 2003, private mwain a Ã©crit...
	bonjour,


> is it possible with the dbmcli to show all tables of a database and to
> have a look at their internal structure (rows, data types etc.)?

For table MA_TABLE, something like:

SELECT COLUMNNAME, DATATYPE, LEN, NULLABLE, MODE, COMMENT
FROM DOMAIN.COLUMNS
WHERE TABLENAME = 'MA_TABLE'

See Sapdb Documentation->system tables
-- 
jean-michel