SQLResultSetColumnNames
DatabaseLink`
DatabaseLink`
SQLResultSetColumnNames
returns a list of {table,column} pairs for each column in a result set.
Details and Options
- To use SQLResultSetColumnNames, you first need to load DatabaseLink using Needs["DatabaseLink`"].
Examples
Basic Examples (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"];rs = SQLResultSetOpen[SQLSelect[conn, "roysched"]];SQLResultSetColumnNames[rs]SQLResultSetClose[rs]CloseSQLConnection[conn]