Wolfram Mathematica Documentation Center
DOCUMENTATION CENTER SEARCH
New to Mathematica? Find your learning path »
DatabaseLink SQL Operations >
DATABASELINK 符号教程 »|参见 »|更多关于 »

SQLTableNames

SQLTableNames[conn]
returns the names of each table in an SQL connection.
更多信息
  • The following options can be given:
"Catalog"Nonedatabase catalog to use
"Schema"Nonedatabase schema to use
"TableType""TABLE"type of table to return
范例关闭所有单元
例   (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 DatabaseExamples` package, as described in .
Get the names of all the tables:
Get the names of tables matching a pattern:
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 DatabaseExamples` package, as described in .
Needs["DatabaseLink`"]
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 DatabaseExamples` package, as described in Using the Example Databases.
In[2]:=
Click for copyable input
Get the names of all the tables:
In[3]:=
Click for copyable input
Out[3]=
Get the names of tables matching a pattern:
In[4]:=
Click for copyable input
Out[4]=
In[5]:=
Click for copyable input
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 DatabaseExamples` package, as described in Using the Example Databases.
Options   (1)
Get the names of all types of tables in a data source:
Ask a question about this page  |  Suggest an improvement  |  Leave a message for the team