> Is there a way to querry a database (whose name you do know) and get a
> list of its tables ? I'd also like to get a list of columns for a table
> (once I know its name)
> I'm trying to build an ad-hoc querry tool.
select tabname, tabid from systables;
to get a list of the table names.
To get columns for that table:
select * from syscolumns where tabid=xxxx;
xxxx is the tabid of the table of interest.
To get the full value of joy,
you must have someone to divide it with. ---Mark Twain