NAME

DROP DATABASE - 刪除一個(gè)數(shù)據(jù)庫(kù)

SYNOPSIS

DROP DATABASE name

DESCRIPTION 描述

DROP DATABASE 刪除一個(gè)現(xiàn)存數(shù)據(jù)庫(kù)的目錄入口并且刪除包含數(shù)據(jù)的目錄。 只有數(shù)據(jù)庫(kù)所有者能夠執(zhí)行這條命令（通常也是數(shù)據(jù)庫(kù)創(chuàng)建者）。

DROP DATABASE 不能撤銷，小心使用！  

PARAMETERS 參數(shù)

name

 要被刪除的現(xiàn)有數(shù)據(jù)庫(kù)名。

NOTES 注意

DROP DATABASE cannot be executed inside a transaction block.

 這條命令在和目標(biāo)數(shù)據(jù)庫(kù)聯(lián)接時(shí)不能執(zhí)行。 通常更好的做法是用 dropdb[dropdb(1)] 程序代替，該程序是此命令的一個(gè)封裝。  

COMPATIBILITY 兼容性

 在 SQL 標(biāo)準(zhǔn)中沒(méi)有 DROP DATABASE 語(yǔ)句。  

SEE ALSO 參見(jiàn)

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