SQLDataTypeInformation
DatabaseLink`
DatabaseLink`
SQLDataTypeInformation
SQLDataTypeInformation[conn]
returns information about the data types that can be stored in an SQL connection.
更多信息和选项
- To use SQLDataTypeInformation, 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["demo"];SQLDataTypeInformation[conn]//TableFormCloseSQLConnection[conn];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.
Options (1)
"ShowColumnHeadings" (1)
Needs["DatabaseLink`"]conn = OpenSQLConnection["demo"];SQLDataTypeInformation[conn, "ShowColumnHeadings" -> True]//TableFormCloseSQLConnection[conn];