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