|Subject||Re: MySQL to Firebird TABLE query|
> In MySQL, I have used the SHOW CREATE TABLE tablename command toThere is no such equivalent in Firebird's SQL. But almost any
> 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`)
> ) TYPE=MyISAM
> from which I can import back again to create a new structure.
> How can I do this in Firebird?
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.