MATHEMATICA FEATURED EXAMPLE

Get Information about Database Tables

DatabaseLink lets you connect to and use databases. Here, SQLTableInformation is used to get meta-information about SQL tables.

    
First create the example database:
Click for copyable input
Click for copyable input
After loading DatabaseLink and opening a connection to a database, get information about the tables:
Click for copyable input
In[17]:=
Click for copyable input
In[18]:=
Click for copyable input
Out[18]//TableForm=
View the same information with column headings:
In[19]:=
Click for copyable input
Out[19]//TableForm=
New to Mathematica? Find your learning path »
Have a question? Ask support »