IDS Forum

Re: how to extract all the tables in on the in....

Posted By: medkba
Date: Friday, 23 November 2012, at 12:55 a.m.

In Response To: Re: how to extract all the tables in on the in.... (Jonathan Leffler)

I want list of table names plus owner and other information one database at
a time
On Nov 23, 2012 1:41 PM, "Jonathan Leffler" <jonathan.leffler@gmail.com>
wrote:

> On Thu, Nov 22, 2012 at 3:11 PM, medkba <medkba@gmail.com> wrote:
>
> > No problem, I want to get from all the tables what we created earlier
> > and choose each database. Each database contains different tables
> > right?
> >
>
> I'm sorry; I'm having difficulty understanding you. Maybe I should go and
> eat some turkey.
>
> Your question "Each database contains different tables?" is understandable
> (I think).
>
> Yes, each database has an independent set of tables. If you have two
> databases dbs1 and dbss2, there may be tables in dbs1 that have no matching
> table in dbs2 and vice versa. There may be tables in dbs1 with the same
> name but different structure from a table in dbs2 (and vice versa). And
> there may be tables in dbs1 and dbs2 with the same name and structure;
> however, it is not guaranteed that these tables have the same contents
> (though that could also happen, usually not by accident). There are other
> possible conditions (such as different names but same structure and
> content), but they probably don't concern us here.
>
> Your statement "I want to get from all the tables what we created earlier
> and choose each database" is giving me comprehension problems. The words
> are individually fine; it's just the assemblage that's causing me grief.
> You previously said "I would like to get table list from one of the
> database tables not system tables". And your original question was "How to
> extract all the tables in Informix database not system". When I suggested
> DB-Schema and DB-Export, you responded:
>
> Is there any sql statement to extract table list
> >
> > I have used this sql statement but not sure > 99 means that
> >
> > SELECT tabname
> > FROM systables
> > WHERE tabid > 99
> > AND tabtype = "T"
> >
>
> And I said that is a perfectly good way to get the list of table names in a
> given database, but you came back with the question below, to which I gave
> an expanded answer that started with 'What do you mean?', and you came back
> yet again with the message at the top.
>
> > On Fri, Nov 23, 2012 at 1:02 AM, Jonathan Leffler wrote:
> > > On Wed, Nov 21, 2012 at 11:45 PM, medkba <medkba@gmail.com> wrote:
> > >> Sorry, actually, I would like to get table list from one of the
> > >> database tables not system tables
> > >
> > > What do you mean?
> >
>
> Please can you go back to the basics, and explain what it is that you want,
> starting from scratch. Do you want a list of table names, or table names
> plus owners,or table names plus owners plus the database that they're found
> in, or something else? Are you wanting the list for one database at a
> time, or for all databases? Do you need to know about columns or anything
> else?
>
> --
> Jonathan Leffler <jonathan.leffler@gmail.com> #include <disclaimer.h>
> Guardian of DBD::Informix - v2011.0612 - http://dbi.perl.org
> "Blessed are we who can laugh at ourselves, for we shall never cease to be
> amused."
>
> --e89a8f2346659773d604cf2240ad
>
>
>
> *******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>

--bcaec50406eaeb4ad804cf233bf3

Messages In This Thread

• how to extract all the tables in on the informix d
  medkba -- Wednesday, 21 November 2012, at 9:05 p.m.
  • Re: how to extract all the tables in on the inform
    Jonathan Leffler -- Wednesday, 21 November 2012, at 10:27 p.m.
    • Re: how to extract all the tables in on the in....
      medkba -- Wednesday, 21 November 2012, at 10:35 p.m.
      • Re: how to extract all the tables in on the in....
        Jonathan Leffler -- Thursday, 22 November 2012, at 2:39 a.m.
        • Re: how to extract all the tables in on the in....
          medkba -- Thursday, 22 November 2012, at 2:45 a.m.
          • Re: how to extract all the tables in on the in....
            Jonathan Leffler -- Thursday, 22 November 2012, at 12:02 p.m.
            • Re: how to extract all the tables in on the in....
              medkba -- Thursday, 22 November 2012, at 6:11 p.m.
              • Re: how to extract all the tables in on the in....
                Jonathan Leffler -- Friday, 23 November 2012, at 12:40 a.m.
                • Re: how to extract all the tables in on the in....
                  medkba -- Friday, 23 November 2012, at 12:55 a.m.
                  • Re: how to extract all the tables in on the in....
                    malc_p -- Friday, 23 November 2012, at 5:40 a.m.
      • Re: how to extract all the tables in on the in....
        John Miller iii -- Thursday, 22 November 2012, at 11:46 a.m.

IDS Forum is maintained by Administrator with WebBBS 5.12.