Sorry...just re-read the subject and realized you're using Interbase. Need coffee. ;) > -----Original Message----- > From: Hutchins, Richard [mailto:Richard.Hutchins@xxxxxxxxxxxxxx] > Sent: Wednesday, February 18, 2004 8:24 AM > To: 'DiZEM PGC'; php-db@xxxxxxxxxxxxx > Subject: RE: Interbase: How to get table structure via SQL ? > > > If you're using MySQL, you can use the DESCRIBE tablename > command. There's a > pretty straightforward (and easy to find) section on the > DESCRIBE command in > the MySQL documentation. > > > > -----Original Message----- > > From: DiZEM PGC [mailto:DiZEM77_PGC@xxxxxxx] > > Sent: Wednesday, February 18, 2004 8:11 AM > > To: php-db@xxxxxxxxxxxxx > > Subject: Interbase: How to get table structure via SQL ? > > > > > > Hi, > > > > does anyone know how to get the Structure of a table using SQL. > > (ex.: SELECT ?RELATION_SOURCE?, RDB$RELATION_NAME FROM > RDB$RELATIONS) > > > > Isn't there any table containing the CREATE STATEMENT for a table? > > Maybe I have to use another command? > > Please help ! > > > > Thx, > > DiZEM > > > > -- > > GMX ProMail (250 MB Mailbox, 50 FreeSMS, Virenschutz, 2,99 > > EUR/Monat...) > > jetzt 3 Monate GRATIS + 3x DER SPIEGEL +++ > http://www.gmx.net/derspiegel +++ > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php