DatabaseLink SQL Operations >

SQLTable

SQLTable[...]
represents a table in an SQL connection.
  • The following option can be given:
"TableType""TABLE"type of table
If you find that the examples in this section do not work as shown, you may need to install or restore the example database with the DatabaseExamples` package, as described in .
List the tables in a connection:
Specify a table in a prepared statement:
Needs["DatabaseLink`"]
If you find that the examples in this section do not work as shown, you may need to install or restore the example database with the DatabaseExamples` package, as described in Using the Example Databases.
In[2]:=
Click for copyable input
List the tables in a connection:
In[3]:=
Click for copyable input
Out[3]=
Specify a table in a prepared statement:
In[4]:=
Click for copyable input
Out[4]=
In[5]:=
Click for copyable input
Ask a question about this page  |  Suggest an improvement  |  Leave a message for the team