Create database by code

[sandro.carrara]

Is there a way to create a new database from Delphi code with a Zeos component (component.createdatabase or "create database db') ?
Thanks

[seawolf]

Yes, there is a way but it depends on the db you want to create.

[jeremicm]

Code: Select all

ZQuery1.SQL.Add('CREATE DATABASE insert-database-name-here');
ZQuery1.ExecSQL;

[sandro.carrara]

Thanks, with zconnection.executedirect('create database xxx') on MySQL works fine, now I'll try with Firebird and Postgresql.