# cockroach sql --insecure --host=localhost:26257
# Welcome to the cockroach SQL interface.
# All statements must be terminated by a semicolon.
# To exit: CTRL + D.
#
# Server version: CockroachDB CCL v2.1.6 (x86_64-unknown-linux-gnu, built 2019/03/04 23:21:07, go1.10.7) (same version as client)
# Cluster ID: 56c72251-e347-4df5-8016-c0a220807a11
#
# Enter \? for a brief introduction.
#
\q
root@localhost:26257/defaultdb> SHOW DATABASES;
database_name
+-----------------+
defaultdb
postgres
system
ttn_lorawan_dev
(4 rows)
Time: 9.753064ms
root@localhost:26257/defaultdb> SHOW TABLES FROM ttn_lorawan_dev;
table_name
+--------------------------+
access_tokens
accounts
api_keys
applications
attributes
authorization_codes
client_authorizations
clients
contact_info_validations
contact_infos
end_device_locations
end_devices
gateway_antennas
gateways
invitations
memberships
organizations
pictures
user_sessions
users
(20 rows)
Time: 1.559261ms
root@localhost:26257/defaultdb> DROP DATABASE ttn_lorawan_dev CASCADE;
DROP DATABASE
Time: 586.676844ms
删除非空数据库要增加 CASCADE 参数。