The following drivers support the DatabaseMetaData.getColumns() method:
  • Aha!
  • Autonomous REST Connector
  • GitHub
  • Google Analytics 4
  • Google BigQuery
  • HubSpot
  • Jira
  • Microsoft Dynamics 365
  • Microsoft SharePoint
  • Oracle Eloqua
  • Oracle Sales Cloud
  • Oracle Service Cloud
  • Salesforce
  • SAP HANA
  • SAP S/4HANA
  • Snowflake
  • TeamCity

The DatabaseMetaData.getColumns() method extends the standard JDBC metadata results returned to include the additional columns described in the following tables.

Table 1. DatabaseMetaData.getColumns() method
Column Data Type Description
IS_EXTERNAL_ID VARCHAR (3), NOT NULL Provides an indication of whether the column can be used as an External ID. External ID columns can be used as the lookup column for insert and upsert operations and foreign-key relationship values. Valid values are:
  • YES: The column can be used as an external ID.
  • NO: The column cannot be used as an external ID.
The standard catalog table SYSTEM_COLUMNS is also extended to include the IS_EXTERNAL_ID column.
LABEL VARCHAR (128) The text label for this column. If not present, this field is null.

The drivers that support DatabaseMetaData.getColumns() extend the standard JDBC metadata results returned by the DatabaseMetaData.getTables() method to include the following additional column.

Table 2. DatabaseMetaData.getTables() Method
Column Data Type Description
LABEL VARCHAR (128) The text label for this table. If not present, this field is null.