dotConnect for SugarCRM Documentation
SYS_TABLES

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 SugarCRM. Always NULL.
TABLE_SCHEMA VARCHAR(128) Second-level container for tables. Not used in dotConnect for SugarCRM. Always NULL.
TABLE_NAME VARCHAR(128) The name of the SugarCRM object.
TABLE_TYPE VARCHAR(10) Type of an object. Always "TABLE".
CUSTOM BIT Indicates whether this object is a predefined SugarCRM 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:

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

Zero value means none of the DML operations are allowed.

API_NAME VARCHAR(128) The original name of the table, generated by SugarCRM.