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.

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?

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.

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