SQLCatalogNames
DatabaseLink`
DatabaseLink`
SQLCatalogNames
SQLCatalogNames[conn]
returns the names of the catalogs in an SQL connection.
更多信息和选项
- To use SQLCatalogNames, you first need to load DatabaseLink using Needs["DatabaseLink`"].
范例
基本范例 (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["demo"];Catalogs in the HSQLDB demo data source:
SQLCatalogNames[conn]CloseSQLConnection[conn];Catalogs in a MySQL installation:
conn = OpenSQLConnection["local mysql sandbox"];SQLCatalogNames[conn]CloseSQLConnection[conn];