OpenSQLConnection (DatabaseLink Symbol)

OpenSQLConnection[src] makes a connection to a data source.OpenSQLConnection[] opens a GUI that helps to make a connection to a data source.

SQLColumnNames (DatabaseLink Symbol)

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

SQLColumn (DatabaseLink Symbol)

SQLColumn[...] represents a column in an SQL table.

SQLCreateTable (DatabaseLink Symbol)

SQLCreateTable[conn, table, columns] creates a new table in an SQL connection.

SQLTableNames (DatabaseLink Symbol)

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

Creating Tables (DatabaseLink Tutorial)

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

DatabaseLink User Guide (DatabaseLink Overview)

Introduction to DatabaseLink Getting Started Database Connections

Creating Tables with Raw SQL (DatabaseLink Tutorial)

The raw SQL command CREATE TABLE creates tables in a database. An alternative is to use the Mathematica command SQLCreateTable, described in "Creating Tables". If you find ...

Deleting Data with Raw SQL (DatabaseLink Tutorial)

The raw SQL command DELETE deletes data from a database. An alternative is to use the Mathematica command SQLDelete, described in "Deleting Data". If you find that the ...

Updating Data with Raw SQL (DatabaseLink Tutorial)

The raw SQL command UPDATE updates data in a database. An alternative is to use the Mathematica command SQLUpdate, described in "Updating Data". If you find that the examples ...