CData Excel Add-In for Google BigQuery 2019 - Online Help
Questions / Feedback?

sys_keycolumns

CData Excel Add-In for Google BigQuery 2019 - Build 19.0.7354

Describes the primary and foreign keys.

The following query retrieves the primary key for the publicdata.samples.github_nested table:

         SELECT * FROM sys_keycolumns WHERE IsKey='True' AND TableName='publicdata.samples.github_nested'
          

Columns

Name Type Description
CatalogName String The name of the database containing the key.
SchemaName String The name of the schema containing the key.
TableName String The name of the table containing the key.
ColumnName String The name of the key column.
IsKey Boolean Whether the column is a primary key in the table referenced in the TableName table.
IsForeignKey Boolean Whether the column is a foreign key referenced in the TableName table.
PrimaryKeyName String The name of the primary key.
ForeignKeyName String The name of the foreign key.
ReferencedCatalogName String The database containing the primary key.
ReferencedSchemaName String The schema containing the primary key.
ReferencedTableName String The table containing the primary key.
ReferencedColumnName String The column name of the primary key.

 
 
Copyright (c) 2020 CData Software, Inc. - All rights reserved.
Build 19.0.7354.0