Interbase and PHP- SHOW TABLE sql command

Ge0rge2

Hello,
I do not know how to get the list of tables in an Interbase databse. When I tried to use the sql command "SHOW TABLE;" in the php function "ibase_query();" I got "Dynamic SQL Error SQL error code = -104 Token unknown - line 1,...". Select commands work well but this not.
Does anybody know where is the problem?
Thanks Ge0rge

Sxooter

show table is a mysqlism. Postgresql does it differently, as I'm sure interbase does as well. You'll have to read the interbase docs to see what to do.

Ge0rge2

Originally posted by Sxooter
show table is a mysqlism. Postgresql does it differently, as I'm sure interbase does as well. You'll have to read the interbase docs to see what to do.

Thanks for your reply, but I am sure I've read the Interbase documantation. "SHOW TABLE" is a regular Interbase SQL command. I've tried this command with the command line Interbase client. Probably there is no way how to make this command work via PHP. Maybe via the ODBC PHP library but that's not what I need. I am bound to the Interbase library.
Thanks once more.

Sxooter

It may be one of those things that the isql client "interprets" for you. i.e. it's not actually SQL, it's a meta command to isql.