RE: [PHP-DB] Interbase: How to get table structure via SQL ?
| From: | Hutchins, Richard | Date: | Wed, 18 Feb 2004 13:24:17 +0000 |
| Subject: | RE: [PHP-DB] Interbase: How to get table structure via SQL ? | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-33001@lists.php.net to get a copy of this message | ||
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@gmx.net]
> Sent: Wednesday, February 18, 2004 8:11 AM
> To: php-db@lists.php.net
> 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