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
>
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 t
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
D]'
Subject: Re: 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 qu
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 "
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 cata
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 g
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
> table
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
