Drop Spanner tables

_usage.md

$ bash drop-spanner-tables.sh <your project> <your spanner instance> <your spanner database>

drop-spanner-tables.sh

#!/bin/bash

project="${1}"
instance="${2}"
database="${3}"

tables="SELECT
  table_name
FROM
  information_schema.tables
WHERE
  table_schema = ''"

for table in $(gcloud --project=${project} spanner databases execute-sql ${database} --instance=${instance} --sql="${tables}" | awk 'NR>1'); do
    gcloud --project=${project} spanner databases execute-sql ${database} --instance=${instance} --sql="DROP TABLE ${table}"
done