dotConnect for Google BigQuery Documentation
The SYS_COLUMNS table lists table columns and their parameters. It has the following columns:
Column Name |
Data Type |
Description |
|---|---|---|
| TABLE_CATALOG | VARCHAR(128) | The Google Cloud project that contains the table. |
| TABLE_SCHEMA | VARCHAR(128) | The dataset that contains the table. |
| TABLE_NAME | VARCHAR(128) | The name of the table which the column belongs to. |
| COLUMN_NAME | VARCHAR(128) | The name of the column. A field of a STRUCT column is returned as a separate column named struct_name.field_name. |
| ORDINAL_POSITION | INT | The position of the column in the table. |
| IS_NULLABLE | VARCHAR(3) | Indicates whether this column can be NULL ("YES" or "NO"). |
| COLUMN_DEFAULT | TEXT | The default value expression of the column. |
| DATA_TYPE | VARCHAR(128) | The provider data type of the column, for example, LONG, STRING, DECIMAL, DATETIMEOFFSET. |
| CHARACTER_MAXIMUM_LENGTH | INT | The maximum length of a STRING or BYTES column. |
| CHARACTER_OCTET_LENGTH | INT | Not used in dotConnect for Google BigQuery. Always NULL. |
| NUMERIC_PRECISION | INT | The precision of a NUMERIC or BIGNUMERIC column. |
| NUMERIC_PRECISION_RADIX | INT | Not used in dotConnect for Google BigQuery. Always NULL. |
| NUMERIC_SCALE | INT | The scale of a NUMERIC or BIGNUMERIC column. |
| DATETIME_PRECISION | INT | Not used in dotConnect for Google BigQuery. Always NULL. |
| CHARACTER_SET_CATALOG | VARCHAR(128) | Not used in dotConnect for Google BigQuery. Always NULL. |
| CHARACTER_SET_SCHEMA | VARCHAR(128) | Not used in dotConnect for Google BigQuery. Always NULL. |
| CHARACTER_SET_NAME | VARCHAR(128) | Not used in dotConnect for Google BigQuery. Always NULL. |
| COLLATION_CATALOG | VARCHAR(128) | Not used in dotConnect for Google BigQuery. Always NULL. |
| COLLATION_SCHEMA | VARCHAR(128) | Not used in dotConnect for Google BigQuery. Always NULL. |
| COLLATION_NAME | VARCHAR(128) | Not used in dotConnect for Google BigQuery. Always NULL. |
| DOMAIN_CATALOG | VARCHAR(128) | Not used in dotConnect for Google BigQuery. Always NULL. |
| DOMAIN_SCHEMA | VARCHAR(128) | Not used in dotConnect for Google BigQuery. Always NULL. |
| DOMAIN_NAME | VARCHAR(128) | Not used in dotConnect for Google BigQuery. Always NULL. |
| ALLOWED_OPERATIONS | INT | Contains a flag value that indicates which DML operations are allowed on this column and is the sum of the following flags:
Zero value means none of the DML operations are allowed (ARRAY columns). |
| HAS_DEFAULT | BIT | Indicates whether the column has a default value. |
| IS_COMPUTED | BIT | Not used in dotConnect for Google BigQuery. Always 0. |
| IS_UNIQUE | BIT | Indicates whether the column is a part of the primary key. |
| DB_TYPE | INT | The numeric representation of the System.Data.DbType value. |
| NATIVE_TYPE | INT | The numeric representation of the BigQueryType value. |
| API_NAME | VARCHAR(128) | The name of the column as it is used in SQL statements. |
| IS_REQUIRED | VARCHAR(3) | Indicates whether the column is declared as NOT NULL (REQUIRED mode): "YES" or "NO". |