DatabaseLink`
DatabaseLink`
SQLSchemaInformation
SQLSchemaInformation[conn]
returns information about the schemas available through an SQL connection.
Details and Options
- 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
Examples
Basic Examples (1)Summary of the most common use cases
In[1]:=1
✖
https://wolfram.com/xid/0wi1pr1mg8lfeh52xrv6u-c1edws
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.
In[2]:=2
✖
https://wolfram.com/xid/0wi1pr1mg8lfeh52xrv6u-kww
This returns the schema details for this database connection:
In[3]:=3
✖
https://wolfram.com/xid/0wi1pr1mg8lfeh52xrv6u-pun
Out[3]=3
In[4]:=4
✖
https://wolfram.com/xid/0wi1pr1mg8lfeh52xrv6u-pnd