WOLFRAM

Wolfram 语言与系统参考资料中心

SQLTableNames[conn]

returns the names of each table in an SQL connection.

SQLTableNames[conn,table]

returns the names matching table.

更多信息和选项
Details and Options Details and Options
范例  
基本范例  
Options  
"TableType"  
参见
技术笔记
相关指南
DatabaseLink`
DatabaseLink`

SQLTableNames

SQLTableNames[conn]

returns the names of each table in an SQL connection.

SQLTableNames[conn,table]

returns the names matching table.

更多信息和选项

  • To use SQLTableNames, you first need to load DatabaseLink using Needs["DatabaseLink`"].
  • The following options can be given:
  • "Catalog"Nonedatabase catalog to use
    "Schema"Nonedatabase schema to use
    "TableType""TABLE"type of table to return

范例

打开所有单元 关闭所有单元

基本范例  (1)

Wolfram Language code: 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 DatabaseLink`DatabaseExamples` package, as described in Using the Example Databases.

Open a connection:

Wolfram Language code: conn = OpenSQLConnection["publisher"];

Get the names of all the tables:

Wolfram Language code: SQLTableNames[conn]

Get the names of tables matching a pattern:

Wolfram Language code: SQLTableNames[conn, "TITLE%"]
Wolfram Language code: CloseSQLConnection[conn];

Options  (1)

"TableType"  (1)

Wolfram Language code: Needs["DatabaseLink`"]

Get the names of all types of tables in a data source:

Wolfram Language code: conn = OpenSQLConnection["publisher"];
Wolfram Language code: SQLTableNames[conn, "TableType" -> SQLTableTypeNames[conn]]
Wolfram Language code: CloseSQLConnection[conn];