DatabaseLink SQL Operations

DatabaseLink is a toolkit for working with SQL databases built into the Wolfram Language. It provides an industrial-strength, ready-made solution for integrating the Wolfram Language with any standard SQL database. Among its functions are those for opening and closing connections to a database and fetching details about the organization of the database, as well as searching, inserting, and deleting data from the database.

Data Access and Manipulation »

SQLSelect  ▪  SQLUpdate  ▪  SQLInsert  ▪  SQLDelete  ▪  SQLExecute  ▪  ...

Database Tables and Data »

SQLCreateTable  ▪  SQLTables  ▪  SQLTableNames  ▪  SQLColumns  ▪  SQLColumnNames  ▪  ...

Connections »

OpenSQLConnection  ▪  $SQLUseConnectionPool  ▪  $SQLTimeout  ▪  ...

Data Resources »

DataSources  ▪  WriteDataSource  ▪  JDBCDrivers  ▪  ...

Database Servers »

SQLServerLaunch  ▪  SQLServerInformation  ▪  ...

Transactions »

SQLBeginTransaction  ▪  SQLSetSavepoint  ▪  ...

Result Sets »

SQLResultSetOpen  ▪  SQLResultSetRead  ▪  ...