Subject | MySQL to Firebird TABLE query |
---|---|
Author | maxtelfer |
Post date | 2004-04-22T06:31:03Z |
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`)
) TYPE=MyISAM
from which I can import back again to create a new structure.
How can I do this in Firebird?
Max
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?
Max