.TH "GCLOUD_ALPHA_SPANNER_DATABASES_DDL_UPDATE" 1



.SH "NAME"
.HP
gcloud alpha spanner databases ddl update \- update the DDL for a Cloud Spanner database



.SH "SYNOPSIS"
.HP
\f5gcloud alpha spanner databases ddl update\fR (\fIDATABASE\fR\ :\ \fB\-\-instance\fR=\fIINSTANCE\fR) [\fB\-\-async\fR] [\fB\-\-ddl\fR=\fIDDL\fR] [\fB\-\-ddl\-file\fR=\fIDDL_FILE\fR] [\fB\-\-proto\-descriptors\-file\fR=\fIPROTO_DESCRIPTORS_FILE\fR] [\fIGCLOUD_WIDE_FLAG\ ...\fR]



.SH "DESCRIPTION"

\fB(ALPHA)\fR Update the DDL for a Cloud Spanner database.



.SH "EXAMPLES"

To add a column to a table in the given Cloud Spanner database, run:

.RS 2m
$ gcloud alpha spanner databases ddl update my\-database\-id \e
    \-\-instance=my\-instance\-id \e
    \-\-ddl='ALTER TABLE test_table ADD COLUMN a INT64'
.RE



.SH "POSITIONAL ARGUMENTS"

.RS 2m
.TP 2m

Database resource \- The Cloud Spanner database of which the ddl to update. The
arguments 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 in
other ways.

To set the \f5project\fR attribute:
.RS 2m
.IP "\(em" 2m
provide the argument \f5database\fR on the command line with a fully specified
name;
.IP "\(em" 2m
provide the argument \f5\-\-project\fR on the command line;
.IP "\(em" 2m
set the property \f5core/project\fR.
.RE
.sp

This must be specified.


.RS 2m
.TP 2m
\fIDATABASE\fR

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

To set the \f5database\fR attribute:
.RS 2m
.IP "\(bu" 2m
provide the argument \f5database\fR on the command line.
.RE
.sp

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

.TP 2m
\fB\-\-instance\fR=\fIINSTANCE\fR

The Cloud Spanner instance for the database.

To set the \f5instance\fR attribute:
.RS 2m
.IP "\(bu" 2m
provide the argument \f5database\fR on the command line with a fully specified
name;
.IP "\(bu" 2m
provide the argument \f5\-\-instance\fR on the command line;
.IP "\(bu" 2m
set the property \f5spanner/instance\fR.
.RE
.sp


.RE
.RE
.sp

.SH "FLAGS"

.RS 2m
.TP 2m
\fB\-\-async\fR

Return immediately, without waiting for the operation in progress to complete.

.TP 2m
\fB\-\-ddl\fR=\fIDDL\fR

Semi\-colon separated DDL (data definition language) statements to run inside
the database. If a statement fails, all subsequent statements in the batch are
automatically cancelled.

.TP 2m
\fB\-\-ddl\-file\fR=\fIDDL_FILE\fR

Path of a file containing semi\-colon separated DDL (data definition language)
statements to run inside the database. If a statement fails, all subsequent
statements in the batch are automatically cancelled. If \-\-ddl_file is set,
\-\-ddl is ignored. One line comments starting with \-\- are ignored.

.TP 2m
\fB\-\-proto\-descriptors\-file\fR=\fIPROTO_DESCRIPTORS_FILE\fR

Path of a file that contains a protobuf\-serialized
google.protobuf.FileDescriptorSet message. To generate it, install and run
\f5protoc\fR with \-\-include_imports and \-\-descriptor_set_out.


.RE
.sp

.SH "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 \fB$ gcloud help\fR for details.



.SH "NOTES"

This command is currently in alpha and might change without notice. If this
command fails with API permission errors despite specifying the correct project,
you might be trying to access an API with an invitation\-only early access
allowlist. These variants are also available:

.RS 2m
$ gcloud spanner databases ddl update
.RE

.RS 2m
$ gcloud beta spanner databases ddl update
.RE