google-big-queryHow do I rename a column in Google BigQuery?
Renaming a column in Google BigQuery is a simple process. The following example code shows how to rename a column from old_name
to new_name
:
ALTER TABLE my_table
RENAME COLUMN old_name TO new_name;
No output is generated from this command.
The code consists of two parts:
ALTER TABLE my_table
: This part of the code specifies the table to be altered.RENAME COLUMN old_name TO new_name;
: This part of the code renames the columnold_name
tonew_name
.
For more information about renaming columns in BigQuery, please see the official documentation.
More of Google Big Query
- ¿Cuáles son las ventajas y desventajas de usar Google BigQuery?
- How do I set up a Google Big Query zone?
- How do I sign in to Google Big Query?
- How do I use the YEAR function in Google BigQuery?
- How can I export data from Google Big Query to an XLSX file?
- How do I use Google BigQuery language to query data?
- How do Google BigQuery and Azure Data Lake compare in terms of performance and cost?
- How do I query Google BigQuery using XML?
- How can I use Google BigQuery to retrieve data from a specific year?
- How can I use Google BigQuery ML to build a machine learning model?
See more codes...