Creating New MySQL Database using sc_macro


I am wondering if anyone has tried or having an idea how to create a new database using sc_macro. The reason i am asking is I have a usecase to create a new database and also create a new connection to associate this database.

Since our sc_execute_sql always requires the connection and not sure if this can based used.