dotConnect for Salesforce Documentation
SYS_COLUMNS

The SYS_COLUMNS table lists available tables and their parameters. It has the following columns:

For more information about field types see Salesforce.com documentation.

Column Name

Data Type

Description
TABLE_CATALOG VARCHAR(128) Top-level container for tables. Not used in dotConnect for Salesforce. Always NULL.
TABLE_SCHEMA VARCHAR(128) Second-level container for tables. Not used in dotConnect for Salesforce. Always NULL.
TABLE_NAME VARCHAR(128) The name of the Salesforce.com or Database.com object which the field belongs to.
COLUMN_NAME VARCHAR(128) The name of a Salesforce.com or Database.com object field.
ORDINAL_POSITION INT The position of the field in the object.
COLUMN_DEFAULT TEXT Default value for the field.
IS_NULLABLE VARCHAR(3) Indicates whether this field can be NULL ("YES" or "NO").
DATA_TYPE VARCHAR(128)

The data type of the field. Can be one of the following values:

  • BINARY - corresponds to the Salesforce.com base64 type.
  • BOOLEAN - corresponds to the Salesforce.com boolean type.
  • BYTE - corresponds to the Salesforce.com byte type.
  • DATE - corresponds to the Salesforce.com date type.
  • DATETIME - corresponds to the Salesforce.com dateTime type.
  • DOUBLE - corresponds to the Salesforce.com double type.
  • INT - corresponds to the Salesforce.com int type.
  • STRING - corresponds to the Salesforce.com string type.
  • TIME - corresponds to the Salesforce.com time type.
CHARACTER_MAXIMUM_LENGTH INT The maximum length of the character or binary data that the field can contain in characters.
CHARACTER_OCTET_LENGTH INT The maximum length of the character or binary data that the field can contain in bytes.
NUMERIC_PRECISION INT The precision of numeric data.
NUMERIC_PRECISION_RADIX INT The precision radix of numeric data.
NUMERIC_SCALE INT The scale of numeric data.
DATETIME_PRECISION INT Not used in dotConnect for Salesforce. Always NULL.
CHARACTER_SET_CATALOG VARCHAR(128) Not used in dotConnect for Salesforce. Always NULL.
CHARACTER_SET_SCHEMA VARCHAR(128) Not used in dotConnect for Salesforce. Always NULL.
CHARACTER_SET_NAME VARCHAR(128) Not used in dotConnect for Salesforce. Always NULL.
COLLATION_CATALOG VARCHAR(128) Not used in dotConnect for Salesforce. Always NULL.
COLLATION_SCHEMA VARCHAR(128) Not used in dotConnect for Salesforce. Always NULL.
COLLATION_NAME VARCHAR(128) Not used in dotConnect for Salesforce. Always NULL.
DOMAIN_CATALOG VARCHAR(128) Not used in dotConnect for Salesforce. Always NULL.
DOMAIN_SCHEMA VARCHAR(128) Not used in dotConnect for Salesforce. Always NULL.
DOMAIN_NAME VARCHAR(128) Not used in dotConnect for Salesforce. Always NULL.
ALLOWED_OPERATIONS INT

Contains flag value that indicates which DML operations are allowed on this object and is the sum of the following flags

  • 1 - INSERT operations are allowed
  • 2 - UPDATE operations are allowed

Zero value means none of the DML operations are allowed.
HAS_DEFAULT BIT Indicates whether the field has the default value.
IS_COMPUTED BIT Indicates whether the field is computed.
IS_UNIQUE BIT Indicates whether the field must have unique values.
DB_TYPE INT Numeric representation of the DbType value.
NATIVE_TYPE INT For internal usage.
API_NAME VARCHAR(128) The original name of the column, generated by Salesforce.com or Database.com.

 

 

© 2011 - 2025 Devart. All Rights Reserved.

support@devart.com