SQLConnection (DatabaseLink Symbol)

SQLConnection[...] is an object that represents a connection to a data source.

SQLConnectionPool (DatabaseLink Symbol)

SQLConnectionPool[...] is an object that represents a connection pool to a data source.

SQLDateTime (DatabaseLink Symbol)

SQLDateTime[datetime] represents date and time information that can be stored in a database.

SQLDelete (DatabaseLink Symbol)

SQLDelete[conn, table] deletes the data in a table in an SQL connection.SQLDelete[conn, table, cond] deletes data that matches cond.

SQLInsert (DatabaseLink Symbol)

SQLInsert[conn, table, cols, data] inserts data into a table in an SQL connection.

SQLResultSetCurrent (DatabaseLink Symbol)

SQLResultSetCurrent[rs] reads the current row from a result set.

SQLResultSetPosition (DatabaseLink Symbol)

SQLResultSetPosition[rs] returns an integer that specifies the current position in a result set.

SQLResultSetTake (DatabaseLink Symbol)

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

SQLStringMatchQ (DatabaseLink Symbol)

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

Schema and Catalogs (DatabaseLink Tutorial)

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