SYS_COLUMNS

The SYS_COLUMNS table provides information about column names, data types, positions, and the tables to which they belong.

Column name	Data type	Description
`TABLE_CATALOG`	`VARCHAR(128)`	Top-level container for tables. Not used. Always `NULL`.
`TABLE_SCHEMA`	`VARCHAR(128)`	Second-level container for tables. Not used. Always `NULL`.
`TABLE_NAME`	`VARCHAR(128)`	The name of the `Salesforce` object to which the field belongs.
`COLUMN_NAME`	`VARCHAR(128)`	The name of a `Salesforce` object field.
`DATA_TYPE`	`VARCHAR(128)`	The data type of the field. The possible values are: `BINARY` – Maps to `base64` in Salesforce. `BOOLEAN` – Maps to `boolean` in Salesforce. `BYTE` – Maps to `byte` in Salesforce. `DATE` – Maps to `date` in Salesforce. `DATETIME` – Maps to `dateTime` in Salesforce. `DOUBLE` – Maps to `double` in Salesforce. `INT` – Maps to `int` in Salesforce. `STRING` – Maps to `string` in Salesforce. `TIME` – Maps to `time` in Salesforce. For more information about data types used by Salesforce, see Primitive Data Types.
`ALLOWED_OPERATIONS`	`INT`	Specifies which DML operations are allowed on this object. The value is the sum of the following flags: `1` – Specifies that `INSERT` operations are allowed. `2` – Specifies that `UPDATE` operations are allowed. A value of `0` means none of the DML operations are allowed.