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:

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).

Meir Kriheli

  There's someone in my head, but it's not me - Pink Floyd

PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

Reply via email to