gcloud spanner databases ddl update

NAME
gcloud spanner databases ddl update - update the DDL for a Cloud Spanner database
SYNOPSIS
gcloud spanner databases ddl update(DATABASE :--instance=INSTANCE)[--async][--ddl=DDL][--ddl-file=DDL_FILE][--proto-descriptors-file=PROTO_DESCRIPTORS_FILE][GCLOUD_WIDE_FLAG]
DESCRIPTION
Update the DDL for a Cloud Spanner database.
EXAMPLES
To add a column to a table in the given Cloud Spanner database, run:
gcloudspannerdatabasesddlupdatemy-database-id--instance=my-instance-id--ddl='ALTER TABLE test_table ADD COLUMN a INT64'
POSITIONAL ARGUMENTS
Database resource - The Cloud Spanner database of which the ddl to update. Thearguments in this group can be used to specify the attributes of this resource.(NOTE) Some attributes are not given arguments in this group but can be set inother ways.

To set theproject attribute:

  • provide the argumentdatabase on the command line with a fullyspecified name;
  • provide the argument--project on the command line;
  • set the propertycore/project.

This must be specified.

DATABASE
ID of the database or fully qualified identifier for the database.

To set thedatabase attribute:

  • provide the argumentdatabase on the command line.

This positional argument must be specified if any of the other arguments in thisgroup are specified.

--instance=INSTANCE
The Cloud Spanner instance for the database.

To set theinstance attribute:

  • provide the argumentdatabase on the command line with a fullyspecified name;
  • provide the argument--instance on the command line;
  • set the propertyspanner/instance.
FLAGS
--async
Return immediately, without waiting for the operation in progress to complete.
--ddl=DDL
Semi-colon separated DDL (data definition language) statements to run inside thedatabase. If a statement fails, all subsequent statements in the batch areautomatically cancelled.
--ddl-file=DDL_FILE
Path of a file containing semi-colon separated DDL (data definition language)statements to run inside the database. If a statement fails, all subsequentstatements in the batch are automatically cancelled. If --ddl_file is set, --ddlis ignored. One line comments starting with -- are ignored.
--proto-descriptors-file=PROTO_DESCRIPTORS_FILE
Path of a file that contains a protobuf-serializedgoogle.protobuf.FileDescriptorSet message. To generate it, install and runprotoc with --include_imports and --descriptor_set_out.
GCLOUD WIDE FLAGS
These flags are available to all commands:--access-token-file,--account,--billing-project,--configuration,--flags-file,--flatten,--format,--help,--impersonate-service-account,--log-http,--project,--quiet,--trace-token,--user-output-enabled,--verbosity.

Run$gcloud help for details.

NOTES
These variants are also available:
gcloudalphaspannerdatabasesddlupdate
gcloudbetaspannerdatabasesddlupdate

Except as otherwise noted, the content of this page is licensed under theCreative Commons Attribution 4.0 License, and code samples are licensed under theApache 2.0 License. For details, see theGoogle Developers Site Policies. Java is a registered trademark of Oracle and/or its affiliates.

Last updated 2025-05-07 UTC.