SQLSchemaInformation
SQLSchemaInformation[conn]
returns information about the schemas available through an SQL connection.
更多信息和选项
范例
基本范例
参见
技术笔记
相关指南
DatabaseLink`
DatabaseLink`
SQLSchemaInformation
SQLSchemaInformation[conn]
returns information about the schemas available through an SQL connection.
更多信息和选项
- To use SQLSchemaInformation, you first need to load DatabaseLink using Needs["DatabaseLink`"].
- The following option can be given:
-
"ShowColumnHeadings" False whether to return headings with the results
范例
基本范例 (1)
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.
conn = OpenSQLConnection["publisher"];This returns the schema details for this database connection:
SQLSchemaInformation[conn]CloseSQLConnection[conn];