This is documentation for Mathematica 6, which was
based on an earlier version of the Wolfram Language.
View current documentation (Version 11.1)
DatabaseLink Tables and Data
DatabaseLink has functions for working with the tables of data in a database. It can create and drop tables, as well as fetch information about the organization of tables in the database.
SQLCreateTable, SQLDropTable create and drop tables
SQLTables, SQLTableNames list tables in an SQL connection
SQLTableInformation list information about the tables
SQLTablePrivileges table access rights
SQLTablePrimaryKeys primary key descriptions
SQLTableIndexInformation table indices and statistics
SQLTableTypeNames supported table types in an SQL connection
SQLDataTypeNames supported data types
SQLDataTypeInformation information about supported data types
SQLColumns, SQLColumnNames list columns in an SQL connection
SQLColumnInformation list information about the columns
SQLColumnPrivileges column access rights
$SQLTimeout how long Mathematica waits while executing queries