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:[EMAIL PROTECTED] > Sent: Wednesday, February 18, 2004 8:11 AM > To: [EMAIL PROTECTED] > Subject: [PHP-DB] 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
