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)]