SQLCreateTable creates a new table in a database. An alternative, using raw SQL, is described in "Creating Tables with Raw SQL". If you find that the examples in this ...

SQLRollbackTransaction[conn] terminates an SQL transaction. SQLRollbackTransaction[conn, savepoint] returns to an SQLSavepoint.

SQLDropTable drops tables from a database. An alternative, using raw SQL, is demonstrated in "Dropping Tables with Raw SQL". If you find that the examples in this tutorial do ...

WriteDataSource[name] writes a new HSQL data source name.WriteDataSource[name, database] writes a new data source to database.

HSQLDB is a relational database engine written in Java that is bundled with DatabaseLink, which also contains a JDBC driver and necessary configuration. It offers a small ...

DataSources[] returns a list of information about named data sources made available through DatabaseResourcesPath.DataSources[name] returns a list of information about the ...

SQLResultSetRead[rs] shifts the current position and then reads a row from a result set.SQLResultSetRead[rs, num] reads num rows from a result set.

SQLColumnNames[conn] returns a list of {table, name} pairs for each column in an SQL connection.

SQLColumnPrivileges[conn] returns a table of access rights about the columns in an SQL connection.

SQLTableNames[conn] returns the names of each table in an SQL connection.