Do not get CREATE statements during forward Engineer
Posted by:
John Clark
Date: November 04, 2008 09:55PM
I have just downloaded and installed workbench 5.0 and created a single table definition. I also added some data to be inserted in the table.
When I select file|Export|Forward Engineer SQL CREATE Script - it does not create the tables or the inserts tothe tables... I can't figure out why... is it because I am using the "free" version? I was expectign that this option woudl completely export the setup for the schema...
Here is my example of the output of the export:
SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0;
SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0;
SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='TRADITIONAL';
CREATE SCHEMA IF NOT EXISTS `PWD_1.0` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci ;
SET SQL_MODE=@OLD_SQL_MODE;
SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS;
SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS;
Subject
Views
Written By
Posted
Do not get CREATE statements during forward Engineer
2887
November 04, 2008 09:55PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.