Engine and collation

[Alain Roger]

Hi,

When i right click on a table and select "copy SQL to clipboard", i get for example such script:

CREATE TABLE IF NOT EXISTS `mydb`.`industries` (
`id` INT(11) NOT NULL AUTO_INCREMENT ,
`code` VARCHAR(100) NOT NULL ,
PRIMARY KEY (`id`) )
ENGINE = MyISAM
DEFAULT CHARACTER SET = utf8
COLLATE = utf8_unicode_ci
COMMENT = ' '"

1. is it possible to get sql script but WITHOUT "schema" ? in my case the
"mydb" schema before table name ?
2. how can i set the same default charset/collation for all tables in this schema ?
3. how can i set the same engine for all tables in this schema ? I have some former tables that stayed in innoDB while in workbench preferences i set MyISAM engine.

thx.

------------------------------------------
what does not kill you, makes you stronger