Create SQL Database on a manually specified directory

Question

I am inserting lots of data into the preinstalled SQL Database in MM:

con= OpenSQLConnection["demo"] > SQLCreateTable[con, SQLTable["anyname"], SQLcolums] > ...

I am running out of disk space on my laptop, so I would love to create an SQL Database on my external USB 3 disk drive. I tried getting it done with the MM DatabaseLink Userguide, but it seems to exceed my understanding. Is there an easy way to do this?

Thanks and regards

Patrick

......

Ok, figured out how to change the storage directory (F = external device):

(* Create Database Folder *)

DBconn = OpenSQLConnection[JDBC["HSQL(Standalone)", "F:\PDB\PDB"], "Name" -> "Database", "Username" -> "Anonymous", "Description" -> "No Description", "Version" -> DatabaseLinkInformation$VersionNumber];

(* Define Table Structure *)

tablestructure = {SQLColumn["column_1", "DataTypeName" -> "INTEGER"], SQLColumn["column_2", "DataTypeName" -> "INTEGER"]};

(* Create Table *)

SQLCreateTable[DBconn, SQLTable["mytable"], tablestructure];

(* Insert any data *)

SQLInsert[DBconn, "mytable", {"column_1", "column_2"}, {{11, 22}, {33, 44}}];

(* Check for success *)

SQLSelect[DBconn, "mytable", ShowColumnHeadings->True] // TableForm;