Wolfram 语言与系统 10.0 (2014)|旧版文档

此为更早版本的 Wolfram 语言文档查看最新文档(版本11.2)
WOLFRAM 语言范例

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=