SQLResultSetShift[rs, num] shifts the current position of a result set by num.

SQLResultSetTake[rs, {m, n}] reads rows m through n from a result set.

SQLStringMatchQ[col, patt] specifies a condition in an SQL query used to test whether the value of a column matches a pattern. The actual format for the pattern varies from ...

SQLTable[...] represents a table in an SQL connection.

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

DatabaseLink provides two styles of commands for working with data: one for those who are familiar with Mathematica and the other for those who are familiar with SQL. ...

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 ...

Database schema and catalogs can be used to hold collections of database components and objects suitable for particular users. They can be particularly useful when working ...

The raw SQL command DROP TABLE drops tables from a database. An alternative is to use the Mathematica command SQLDropTable, described in "Dropping Tables". If you find that ...

JavaBlock[expr] causes all new Java objects returned to Mathematica during the evaluation of expr to be released when expr finishes. It is an error to refer to such an object ...