Get hands-on experience with 20+ free Google Cloud products and $300 in free credit for new customers.

Big query alter table add column after a specific column

RC1
Bronze 4
Bronze 4

Is it possible to alter table and add a column after a specific column in Big query ? something like Alter table <abc> add column <mnc> after <column_name> . If not then are there any other ways to do and receive the same result ?

0 1 6,704
1 REPLY 1

You can modify a table schema following the documentation, there are different ways to modify a schema by using SQL data definition language (DDL)