My response is old but for the benefit of others that may read this here is the code to create a database using SQLDB:
program bCreateTable;
{$mode objfpc}{$H+}
uses
Classes,
sqldb,
SqldbExampleUnit;
begin
ReadIniFile;
CreateFConnection;
CreateFTransaction;
Fconnection.Transaction := Ftransaction;
Fconnection.ExecuteDirect('create table FPDEV ( ' +
' id INT NOT NULL, ' +
' Name VARCHAR(50), ' +
' Email CHAR(50), ' +
' Birthdate Date, ' +
' PRIMARY KEY (id) ' +
') ');
FTransaction.Commit;
Ftransaction.Free;
Fconnection.Free;
end.
John