Results 1 to 4 of 4
  1. #1
    Join Date
    Dec 2005
    Posts
    2

    Arrow Unanswered: Need query for getting the table information

    I have a database say "mydb" and i have tables in that with different owners
    I want a query which gets me all the information regarding the table.

    For example if i give the tablename as emp then i want the output as

    empno Integer --
    ename char 20
    doj date --
    desig varchar 30

    Please help me out i am in a serious need of it.
    Last edited by vkagiri; 12-02-05 at 14:22.

  2. #2
    Join Date
    Feb 2005
    Posts
    43
    From the command line you could use the 'dbschema' command.

    $ dbschema -d <database> -t <table>

    So, using your examples:

    $ dbschema -d mydb -t emp

    You can also get information on all tables:

    $ dbschema -d mydb -t all

    Does this help you?

  3. #3
    Join Date
    Dec 2005
    Posts
    2

    my rquirement is to embed this in to a esql code

    Hi,
    the command u gave me works good when i do from command prompt but
    my rquirement is to embed this in to a esql code so that i can populate the result got by this on to a gui.


    please help me out.

  4. #4
    Join Date
    Nov 2003
    Location
    sweden
    Posts
    17
    Hi!

    whith this sql you can get al linfo about the table or view.
    you can run this through dbaccess or you can make a script that take an arg which could be the tabname and run it.

    select *
    from systables
    where tabname = ' table name '

    good luck
    Linux

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •