The descriptor fields consist of header fields and record fields. The list of supported descriptor fields is provided in the following tables. It is important to understand that descriptors are new to ODBC 3.x and that there are no restrictions on the values for the supported descriptor fields.
Header Fields
Header Field |
SQL_DESC_ALLOC_TYPE |
SQL_DESC_ARRAY_SIZE |
SQL_DESC_ARRAY_STATUS_PTR |
SQL_DESC_BIND_OFFSET_PTR |
SQL_DESC_BIND_TYPE |
SQL_DESC_COUNT |
SQL_DESC_ROWS_PROCESSED_PTR |
Record Fields
Record Field |
SQL_DESC_AUTO_UNIQUE_VALUE |
SQL_DESC_BASE_COLUMN_NAME |
SQL_DESC_BASE_TABLE_NAME |
SQL_DESC_CASE_SENSITIVE |
SQL_DESC_CONCISE_TYPE |
SQL_DESC_DATA_PTR |
SQL_DESC_DATETIME_INTERVAL_CODE |
SQL_DESC_DATETIME_INTERVAL_PRECISION |
SQL_DESC_DISPLAY_SIZE |
SQL_DESC_FIXED_PREC_SCALE |
SQL_DESC_INDICATOR_PTR |
SQL_DESC_LENGTH |
SQL_DESC_LITERAL_PREFIX |
SQL_DESC_LITERAL_SUFFIX |
SQL_DESC_LOCAL_TYPE_NAME |
SQL_DESC_NAME |
SQL_DESC_NULLABLE |
SQL_DESC_OCTET_LENGTH |
SQL_DESC_OCTET_LENGTH_PTR |
SQL_DESC_PARAMETER_TYPE |
SQL_DESC_PRECISION |
SQL_DESC_ROWVER |
SQL_DESC_SCALE |
SQL_DESC_SEARCHABLE |
SQL_DESC_TYPE |
SQL_DESC_TYPE_NAME |
SQL_DESC_UNNAMED |
SQL_DESC_UNSIGNED |
SQL_DESC_UPDATABLE |