Subject Re: MySQL to Firebird TABLE query
Author Roman Rokytskyy
> In MySQL, I have used the SHOW CREATE TABLE tablename command to
> export and download the database structure from a Java servlet.
> This gives something like:
> CREATE TABLE `tablename` (
> `field1` int(11) NOT NULL default '0',
> `field2` int(11) default '0',
> `field3` char varying(11) default '0',
> PRIMARY KEY (`field1`),
> KEY `IDX_data_field1` (`field1`,`field2`)
> from which I can import back again to create a new structure.
> How can I do this in Firebird?

There is no such equivalent in Firebird's SQL. But almost any
management tool knows how to extract metadata. Being just JDBC driver
JayBird does not provide such capabilities.

If you need metadata information for the whole database and do not
care if they are in text or as a transportable backup, you can always
exec gbak and pass switch to backup metadata information only.

Hope this helps.

Best regards,
Roman Rokytskyy