SQLTable (DatabaseLink Symbol)

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

SQLArgument (DatabaseLink Symbol)

SQLArgument[arg1, arg2, ...] holds a sequence of arguments to an SQL query.

Column Structure (DatabaseLink Tutorial)

This section discusses commands that get information about database columns. If you find that the examples in this section do not work as shown, you may need to install or ...

SQLSelect (DatabaseLink Symbol)

SQLSelect[conn, table] extracts data from a table in an SQL connection. SQLSelect[conn, table, cols] extracts data from particular columns.SQLSelect[conn, table, cols, cond] ...

Result Sets (DatabaseLink Tutorial)

When many rows of data are returned from a database query, a significant amount of memory may be required to hold the result. If all of the data does not need to be available ...

SQLTableInformation (DatabaseLink Symbol)

SQLTableInformation[conn] returns a list of information about the tables in an SQL connection.

SQLTableTypeNames (DatabaseLink Symbol)

SQLTableTypeNames[conn] returns the types of table supported in an SQL connection.

SQLDataTypeInformation (DatabaseLink Symbol)

SQLDataTypeInformation[conn] returns information about the data types that can be stored in an SQL connection.

Security and Authentication (DatabaseLink Tutorial)

Many SQL databases can be configured to require a username and password when a connection is made. This is useful for preventing unwanted access and restricting the range of ...

SQLColumnInformation (DatabaseLink Symbol)

SQLColumnInformation[conn] returns a list of information about the columns in an SQL connection.