count no. of tables
How we can count total number of tables in a Informix database 7.13.
select count(*) from systables where tabid >= 100;
That will count all tables in the database except the system catalog
tables. System catalog tables have a tabid < 100.
Art
Art S. Kagel
Oninit (www.oninit.com)
IIUG Board of Directors (art@iiug.org)
Disclaimer: Please keep in mind that my own opinions are my own opinions and
do not reflect on my employer, Oninit, the IIUG, nor any other organization
with which I am associated either explicitly or implicitly. Neither do
those opinions reflect those of other individuals affiliated with any entity
with which I am affiliated nor those of the entities themselves.
On Mon, Oct 5, 2009 at 3:04 PM, DEEPAK JOSHI <djoshih@hotmail.com> wrote:
> How we can count total number of tables in a Informix database 7.13.
>
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
--0023545bd760aaae9b047535cd65
and tabtype = 'T' ... unless you want views and synonyms ....
Peter Logan
Senior Database Administrator
Phone: 616/878-8309
From:
"Art Kagel" <art.kagel@gmail.com>
To:
ids@iiug.org
Date:
10/05/2009 04:18 PM
Subject:
Re: count no. of tables [17343]
Sent by:
ids-bounces@iiug.org
select count(*) from systables where tabid >= 100;
That will count all tables in the database except the system catalog
tables. System catalog tables have a tabid < 100.
Art
Art S. Kagel
Oninit (www.oninit.com)
IIUG Board of Directors (art@iiug.org)
Disclaimer: Please keep in mind that my own opinions are my own opinions
and
do not reflect on my employer, Oninit, the IIUG, nor any other
organization
with which I am associated either explicitly or implicitly. Neither do
those opinions reflect those of other individuals affiliated with any
entity
with which I am affiliated nor those of the entities themselves.
On Mon, Oct 5, 2009 at 3:04 PM, DEEPAK JOSHI <djoshih@hotmail.com> wrote:
> How we can count total number of tables in a Informix database 7.13.
>
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
--0023545bd760aaae9b047535cd65
*******************************************************************************
Forum Note: Use "Reply" to post a response in the discussion forum.
True. 8-(
Art
Art S. Kagel
Oninit (www.oninit.com)
IIUG Board of Directors (art@iiug.org)
Disclaimer: Please keep in mind that my own opinions are my own opinions and
do not reflect on my employer, Oninit, the IIUG, nor any other organization
with which I am associated either explicitly or implicitly. Neither do
those opinions reflect those of other individuals affiliated with any entity
with which I am affiliated nor those of the entities themselves.
On Mon, Oct 5, 2009 at 4:19 PM, Peter_Logan@spartanstores.com <
Peter_Logan@spartanstores.com> wrote:
> and tabtype = 'T' ... unless you want views and synonyms ....
>
> Peter Logan
> Senior Database Administrator
> Phone: 616/878-8309
>
> From:
> "Art Kagel" <art.kagel@gmail.com>
> To:
> ids@iiug.org
> Date:
> 10/05/2009 04:18 PM
> Subject:
> Re: count no. of tables [17343]
> Sent by:
> ids-bounces@iiug.org
>
> select count(*) from systables where tabid >= 100;>
> That will count all tables in the database except the system catalog
> tables. System catalog tables have a tabid < 100.
>
> Art
>
> Art S. Kagel
> Oninit (www.oninit.com)
> IIUG Board of Directors (art@iiug.org)
>
> Disclaimer: Please keep in mind that my own opinions are my own opinions
> and
> do not reflect on my employer, Oninit, the IIUG, nor any other
> organization
> with which I am associated either explicitly or implicitly. Neither do
> those opinions reflect those of other individuals affiliated with any
> entity
> with which I am affiliated nor those of the entities themselves.
>
> On Mon, Oct 5, 2009 at 3:04 PM, DEEPAK JOSHI <djoshih@hotmail.com> wrote:
>
> > How we can count total number of tables in a Informix database 7.13.
> >
> >
> >
> >
>
>
>
*******************************************************************************
>
> > Forum Note: Use "Reply" to post a response in the discussion forum.
> >
> >
>
> --0023545bd760aaae9b047535cd65
>
>
>
>
*******************************************************************************
>
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
--001517475f1c12fcb7047535e352
Thank you so much as always.