Subject Re: [firebird-support] Re: Tables of a database and columns of a table
Author W O
Hello Jonathan

Thank you for your answer.

Yes, I did, but it doesnt work. SQLTABLES() show me the system tables but
not my own tables.

And SQLCOLUMNS() works when using the parameter FOXPRO, but not when using
NATIVE and I need, native :-(

Greetings.

Walter.



On Thu, Mar 31, 2011 at 11:12 PM, realoldgeek2008 <
jonathan.finch@...> wrote:

>
>
> I recall you're using Visual Foxpro. Have you tried its SQLTABLES() and
> SQLCOLUMNS() functions?
>
> Jonathan
>
>
> --- In firebird-support@yahoogroups.com, W O <sistemas2000profesional@...>
> wrote:
> >
> > Hello everybody
> >
> > Is it possible for an external program know which are the tables of a
> > Database?
> >
> > And which are the columns of a table?
> >
> > In ISQL I can write:
> > SHOW TABLES;
> >
> > SHOW TABLE MyTable;
> >
> > And it works, but if I want to get that data from my program, what can I
> do?
> >
> > Thanks in advance.
> >
> > Walter.
> >
> >
> > [Non-text portions of this message have been removed]
> >
>
>
>


[Non-text portions of this message have been removed]