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
- How do I create and use a user-defined function (UDF) in Google BigQuery?
- How can I learn to use Google BigQuery?
- How can I use Google BigQuery on a Windows system?
- How can I compare Google BigQuery and Amazon Redshift for software development?
- How can I use Google Big Query with Udemy?
- How do I use the UNION clause in Google BigQuery?
- How can I use Google BigQuery references in my software development project?
- How do Google BigQuery and MySQL compare in terms of performance and scalability?
- How do I use Google Big Query SQL for software development?
- How do I use Google BigQuery LIKE statements?
See more codes...