|
SOLUTIONS
|
DATABASELINK 符号
SQLColumnInformation
SQLColumnInformation[conn]
returns a list of information about the columns in an SQL connection.
更多信息更多信息
- To use SQLColumnInformation, 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
范例范例打开所有单元关闭所有单元
基本范例 (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]//Short= | |
![]() | |
Get information for all columns from tables whose names start with "SA":
| In[4]:= |
Out[4]//TableForm= | |
![]() | |
Get information for all columns from a particular table:
| In[5]:= |
Out[5]//TableForm= | |
![]() | |
| In[6]:= |
Out[6]//TableForm= | |
![]() | |
Get information for columns whose names begin with "V" from all tables:
| In[7]:= |
Out[7]//TableForm= | |
![]() | |
| In[8]:= |
Out[8]//TableForm= | |
![]() | |
| In[9]:= |
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.
Mathematica 9 is now available!
New to Mathematica?
Find your learning path »
Have a question?
Ask support »






