WOLFRAM LANGUAGE 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:
In[1]:=
Click for copyable input
In[2]:=
Click for copyable input
After loading DatabaseLink and opening a connection to a database, get information about the tables:
In[3]:=
Click for copyable input
In[4]:=
Click for copyable input
In[5]:=
Click for copyable input
Out[5]//TableForm=
View the same information with column headings:
In[6]:=
Click for copyable input
Out[6]//TableForm=