sp_sqlgetinfo

Provides information about SQL grammar, syntax, and capabilities that the target DBMS supports.

Syntax

sp_sqlgetinfo [attribute_name]

Parameters

Usage

  • This function corresponds to the ODBC function SQLGetInfo.

  • If this procedure is called but no option is specified, the result set includes all SQL options.

  • If the attribute is not found in the internal table, the access service returns an error.

  • If the parameter is not provided, the access service returns a result set of all supported SQL options.

Format for sp_sqlgetinfo

sql_option

varchar(30)

not null

sql_value

varchar(255)

null
Note: If the sql_value column is NULL, this option is not supported for the target DBMS.
Parent topic: ECDA Option for ODBC and Adaptive Server System Procedures