The SYS_TABLES table lists available tables and their parameters. It has the following columns:
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. |
TABLE_TYPE | VARCHAR(10) | Type of an object. Always "TABLE". |
CUSTOM | BIT | Indicates whether this object is a predefined Salesforce.com object or a custom one. |
CAN_QUERY | BIT | Indicates whether the SELECT query to this object can be executed. |
ALLOWED_OPERATIONS | INT | Contains flag value that indicates which DML operations are allowed on this object and is the sum of the following flags:
Zero value means none of the DML operations are allowed. |
API_NAME | VARCHAR(128) | The original name of the table, generated by Salesforce.com or Database.com. |