skip to main content
JDBC Extensions : DatabaseMetaData interface
  

Try DataDirect Drivers Now

DatabaseMetaData interface

The drivers for Oracle Eloqua, Oracle Sales Cloud, Oracle Service Cloud, and Salesforce extend the standard JDBC metadata results returned by the DatabaseMetaData.getColumns() method to include the following additional columns.
Table 30. 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 for Oracle Eloqua, Oracle Sales Cloud, Oracle Service Cloud, and Salesforce extend the standard JDBC metadata results returned by the DatabaseMetaData.getTables() method to include the following additional column.
Table 31. DatabaseMetaData.getTables() Method
Column
Data Type
Description
LABEL
VARCHAR (128)
The text label for this table. If not present, this field is null.