KingbaseES(金仓)删除数据库
删除数据库
|
1 |
DROP DATABASE water; |
如果删除的时候有报错
|
1 2 |
ERROR: database "water" is being accessed by other users DETAIL: There is 1 other session using the database. |
表示现在数据库有链接 不能删除数据库
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 |
-- 1. 查询是谁在连 SELECT pid, usename, application_name, client_addr, state, query_start, left(query, 80) AS query FROM sys_stat_activity WHERE datname = 'water' AND pid <> pg_backend_pid(); -- 2. 断开除自己以外的所有 water 连接 SELECT sys_terminate_backend(pid) FROM sys_stat_activity WHERE datname = 'water' AND pid <> pg_backend_pid(); -- 若 sys_terminate_backend 不存在,可试 PostgreSQL 写法: SELECT pg_terminate_backend(pid) FROM sys_stat_activity WHERE datname = 'water' AND pid <> pg_backend_pid(); |
然后再执行你原来的命令,例如:
|
1 |
DROP DATABASE water; |