Justtechjobs.com Find a programming school near you






Online Campus Both


php-db | 2001041

Re: [PHP-DB] column names From: Mauricio Junqueira (mauzero <email protected>)
Date: 04/03/01

Meir kriheli wrote:

> On Tuesday 03 April 2001 23:10, Mauricio Junqueira wrote:
>> HI,
>>
>> does anyone knows how to retrive information about the columns names of a
>> table?
>> I know that is possible to use show table mytable using isql but
>> I need to get information about the columns using sql.
>> that information is to be accessed with a php script. so, I'm looking
>> for something resembling "select info from table...."
>>
>> How may I supposed to do that?
>
> Hi Mauricio,
>
> I guess you're using Interbase (isql).
>
> The system table your looking for is named RDB$RELATION_FIELDS
>
> Your select should be something like:
>
> select RDB$FIELD_NAME from RDB$RELATION_FIELDS where
> RDB$RELATION_NAME = 'your_table_name'
>
> I'm building a new system, and I don't have an installation of Interbase
> I can check this on. I've got it from the Interbase documentation (the
> LANGREF.pdf file).
>
> HTH

Thank you so much,
It was exactly what I was looking for.
I will now give deep look on those system tables. 

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: php-db-unsubscribe <email protected>
For additional commands, e-mail: php-db-help <email protected>
To contact the list administrators, e-mail: php-list-admin <email protected>