gcloud alpha spanner rows delete - delete a row in a Cloud Spanner database
gcloud alpha spanner rows delete --keys=[KEY,...] --table=TABLE (--database=DATABASE : --instance=INSTANCE) [GCLOUD_WIDE_FLAG ...]
To delete a row with primary keys of SingerId=1,SingName=abc in table Singers under my-database and my-instance, run:
$ gcloud alpha spanner rows delete --table=Singers \ --database=my-database --instance=my-instance --keys=1,abc
- --keys=[KEY,...]
The primary key values of the row to delete.
- --table=TABLE
The Cloud Spanner table name.
- Database resource - The Cloud Spanner database in which to delete a row. 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 project attribute:
- —
provide the argument --database on the command line with a fully specified name;
- —
provide the argument --project on the command line;
- —
set the property core/project.
This must be specified.
- --database=DATABASE
ID of the database or fully qualified identifier for the database. To set the database attribute:
provide the argument --database on the command line.
This flag argument must be specified if any of the other arguments in this group are specified.
- --instance=INSTANCE
The Cloud Spanner instance for the database. To set the instance attribute:
provide the argument --database on the command line with a fully specified name;
provide the argument --instance on the command line;
set the property spanner/instance.
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.
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:
$ gcloud spanner rows delete
$ gcloud beta spanner rows delete