dotConnect for Zoho Books Documentation
In This Topic
    SYS_TABLES
    In This Topic

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