Please enable JavaScript to view this site.

ESL Documentation

Zoom Window Out
Larger Text | Smaller Text
Hide Page Header
Show Expanding Text
Print Topic
Send Mail Feedback
Share This Topic
Save Permalink URL

Navigation: ESL Documentation > ESL SQL Executable Support > Overview of SQL Executable Support > Commands

Inquiry Commands

Scroll Prev Top Next More

Inquiry commands return informational messages, usually about a SQL select statement, such as the SQL data types, or names, of columns that appear in the statement. Most inquiry commands accept a SQL statement as a parameter.

Command	Description
columns	(ODBC only) Display column information for a table.
datasources	(ODBC only) Display a list of ODBC datasources.
display	Displays the current configuration state.
foreignkeys	(ODBC only) Display a list of keys that connect tables.
indexes	(ODBC only) Display a list indexes for a table.
names	Parses the select statement and delivers an informational message describing the name of each column that will appear in the result table.
primarykeys	(ODBC only) Display a list of keys within a table.
tables	(ODBC only) Display a list of database objects.
types	Parses the select statement and delivers an informational message describing the SQL data type of each column that will appear in the result table.
widths	Causes the program to parse the select statement and deliver an informational message describing the maximum possible length of each column selected, with each column's width expressed as a set command.