|
SOLUTIONS
|
DATABASELINK 符号
SQLTableInformation
SQLTableInformation[conn]
returns a list of information about the tables in an SQL connection.
更多信息更多信息
- To use SQLTableInformation, you first need to load DatabaseLink using Needs["DatabaseLink`"].
- The following options can be given:
-
"Catalog" None database catalog to use "Schema" None database schema to use "ShowColumnHeadings" False whether to return headings with the results "TableType" "TABLE" type of table to return
范例范例打开所有单元关闭所有单元
基本范例 (1)基本范例 (1)
| In[1]:= |
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
package, as described in Using the Example Databases.
| In[2]:= |
| In[3]:= |
Out[3]//TableForm= | |
![]() | |
Get information for a specific table:
| In[4]:= |
Out[4]//TableForm= | |
![]() | |
Get information for tables that match a pattern:
| In[5]:= |
Out[5]//TableForm= | |
![]() | |
| In[6]:= |
Mathematica 9 is now available!
New to Mathematica?
Find your learning path »
Have a question?
Ask support »



