show tables

[elpako]

how to show all tables in current database ?

[Hugo Kornelis]

Re: show tables

On Mon, 23 Aug 2004 13:01:34 +0200, elpako wrote:
[color=blue]
>how to show all tables in current database ?[/color]

Hi elpako,

SELECT *
FROM INFORMATION_SCH EMA.TABLES
WHERE TABLE_TYPE = 'BASE TABLE'


Best, Hugo
--

(Remove _NO_ and _SPAM_ to get my e-mail address)