NAME
DROP DATABASE - 删除一个数据库
SYNOPSIS
DROP DATABASE name
DESCRIPTION 描述
DROP DATABASE 删除一个现存数据库的目录入口并且删除包含数据的目录。 只有数据库所有者能够执行这条命令(通常也是数据库创建者)。
DROP DATABASE 不能撤销,小心使用!
PARAMETERS 参数
- name
要被删除的现有数据库名。
NOTES 注意
DROP DATABASE cannot be executed inside a transaction block.
这条命令在和目标数据库联接时不能执行。 通常更好的做法是用 dropdb[dropdb(1)] 程序代替,该程序是此命令的一个封装。
COMPATIBILITY 兼容性
在 SQL 标准中没有 DROP DATABASE 语句。
SEE ALSO 参见
CREATE DATABASE [create_database(7)]
#p#
NAME
DROP DATABASE - remove a database
SYNOPSIS
DROP DATABASE name
DESCRIPTION
DROP DATABASE drops a database. It removes the catalog entries for the database and deletes the directory containing the data. It can only be executed by the database owner. Also, it cannot be executed while you or anyone else are connected to the target database. (Connect to template1 or any other database to issue this command.)
DROP DATABASE cannot be undone. Use it with care!
PARAMETERS
- name
- The name of the database to remove.
NOTES
DROP DATABASE cannot be executed inside a transaction block.
This command cannot be executed while connected to the target database. Thus, it might be more convenient to use the program dropdb [dropdb(1)] instead, which is a wrapper around this command.
COMPATIBILITY
The is no DROP DATABASE statement in the SQL standard.
SEE ALSO
CREATE DATABASE [create_database(7)]