SYS_TABLES contains information about tables and their properties.
| Column name | Data type | Description |
|---|---|---|
TABLE_CATALOG |
VARCHAR(128) |
A top-level container for tables. Not used. Always NULL. |
TABLE_SCHEMA |
VARCHAR(128) |
A second-level container for tables. Not used. Always NULL. |
TABLE_NAME |
VARCHAR(128) |
The name of the object. |
TABLE_TYPE |
VARCHAR(10) |
The type of the object. Always TABLE. |
CUSTOM |
BIT |
Specifies whether the object is predefined (0) or custom (1). |
CAN_QUERY |
BIT |
Specifies whether the object can be queried (1) or not (0). |
ALLOWED_OPERATIONS |
INT |
Specifies which DML operations are allowed on this object. The value is the sum of the following flags:
|
API_NAME |
VARCHAR(128) |
The original name of the table, as generated by Dynamics 365. |