If one just needs the schema try this command: *show create table*
after opening the database this will return data like this 2004_INV CREATE TABLE `2004_INV` ( `ID` int(11) NOT NULL, `DATE_CREATE` date NOT NULL, `DATE_CHANGE` date NOT NULL, `BRIEF_DESC` varchar(255) NOT NULL, `DESCRIPTION` varchar(255) NOT NULL, `CATEGORY` varchar(255) NOT NULL, `CURRENT_LOC` varchar(255) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1 remove the tablename ( in this case "2004_INV" ) and you have ready to run 'table creator' code for the table _______________________________________________ use-revolution mailing list [email protected] Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution
