I do this with
select db;
show tables;
then parse through the result.
Niclas Hedhman wrote:
On Wednesday 09 October 2002 21:43, Inbal Ovadia wrote:
Hi all,
There is a way to know if I have table x in my db?
Let's say some catalog tables that hold information about the db like
tables
Hi all,
There is a way to know if I have table x in my db?
Let's say some catalog tables that hold information about the db like tables
name etc.
and i can do query like select tables from catalogName and get all the
tables in the db
thanks :)
Inbal
On Wed, Oct 09, 2002 at 03:43:15PM +0200, Inbal Ovadia wrote:
Hi all,
There is a way to know if I have table x in my db?
Let's say some catalog tables that hold information about the db like tables
name etc.
and i can do query like select tables from catalogName and get all the
tables in
On Wed, 9 Oct 2002, Inbal Ovadia wrote:
Hi all,
There is a way to know if I have table x in my db?
Let's say some catalog tables that hold information about the db like tables
name etc.
and i can do query like select tables from catalogName and get all the
tables in the db
Hi,
I guess
show tables;
On Wednesday, Oct 9, 2002, at 05:43 America/Anchorage, Inbal Ovadia
wrote:
Hi all,
There is a way to know if I have table x in my db?
Let's say some catalog tables that hold information about the db like
tables
name etc.
and i can do query like select tables from
On Wed, 9 Oct 2002, Brian Reichert wrote:
On Wed, Oct 09, 2002 at 03:43:15PM +0200, Inbal Ovadia wrote:
Hi all,
There is a way to know if I have table x in my db?
Let's say some catalog tables that hold information about the db like tables
name etc.
and i can do query like select
: information about the tables in the database
On Wed, 9 Oct 2002, Inbal Ovadia wrote:
Hi all,
There is a way to know if I have table x in my db?
Let's say some catalog tables that hold information about the db like
tables
name etc.
and i can do query like select tables from catalogName and get
Sure you can.
show tables like 's%' from mydatabase;
Iikka Meriläinen wrote:
On Wed, 9 Oct 2002, Inbal Ovadia wrote:
Hi all,
There is a way to know if I have table x in my db?
Let's say some catalog tables that hold information about the db like tables
name etc.
and i can do query like
On Wednesday 09 October 2002 21:43, Inbal Ovadia wrote:
Hi all,
There is a way to know if I have table x in my db?
Let's say some catalog tables that hold information about the db like
tables name etc.
and i can do query like select tables from catalogName and get all the
tables in the db