- 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] [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:
gcloud spanner databases ddl update my-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. 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
projectattribute:-
provide the argument
databaseon the command line with a fully specified name; -
provide the argument
--projecton the command line; -
set the property
core/project.
This must be specified.
DATABASE-
ID of the database or fully qualified identifier for the database.
To set the
databaseattribute:-
provide the argument
databaseon the command line.
This positional argument must be specified if any of the other arguments in this group are specified.
-
provide the argument
--instance=INSTANCE-
The Cloud Spanner instance for the database.
To set the
instanceattribute:-
provide the argument
databaseon the command line with a fully specified name; -
provide the argument
--instanceon the command line; -
set the property
spanner/instance.
-
provide the argument
-
provide the argument
-
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.
- 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 the database. If a statement fails, all subsequent statements in the batch are automatically 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 subsequent statements in the batch are automatically cancelled. If --ddl_file is set, --ddl is ignored. One line comments starting with -- are ignored.
- 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 helpfor details. - NOTES
-
These variants are also available:
gcloud alpha spanner databases ddl updategcloud beta spanner databases ddl update
Except as otherwise noted, the content of this page is licensed under the Creative Commons Attribution 4.0 License, and code samples are licensed under the Apache 2.0 License. For details, see the Google Developers Site Policies. Java is a registered trademark of Oracle and/or its affiliates.
Last updated 2024-02-06 UTC.
[{
"type": "thumb-down",
"id": "hardToUnderstand",
"label":"Hard to understand"
},{
"type": "thumb-down",
"id": "incorrectInformationOrSampleCode",
"label":"Incorrect information or sample code"
},{
"type": "thumb-down",
"id": "missingTheInformationSamplesINeed",
"label":"Missing the information/samples I need"
},{
"type": "thumb-down",
"id": "otherDown",
"label":"Other"
}]
[{
"type": "thumb-up",
"id": "easyToUnderstand",
"label":"Easy to understand"
},{
"type": "thumb-up",
"id": "solvedMyProblem",
"label":"Solved my problem"
},{
"type": "thumb-up",
"id": "otherUp",
"label":"Other"
}]