public void CreateSchema(string schemaName)
{
var sql = SqlScriptHelper.CreateSchema(schemaName);
// also create sequence for autoincrement
sql += SqlScriptHelper.CreateSequence(SEQUENCE, schemaName);
ExecuteNonQuery(sql);
}
public void DropSchemaWithObjects(string schemaName)
{
var sql = SqlScriptHelper.DropSchemaWithObjects(schemaName);
ExecuteNonQuery(sql);
}
