DROP DATABASE 中文man页面

系统
DROP DATABASE 删除一个现存数据库的目录入口并且删除包含数据的目录。 只有数据库所有者能够执行这条命令(通常也是数据库创建者)。

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

责任编辑:韩亚珊 来源: CMPP.net
相关推荐

2011-08-24 14:31:48

DROP LANGUA中文man

2011-08-24 14:19:14

DROP DOMAIN中文man

2011-08-24 14:35:33

DROP OPERAT中文man

2011-08-24 14:13:27

DROP CONVER中文man

2011-08-24 14:06:36

DROP AGGREG中文man

2011-08-24 14:22:11

DROP FUNCTI中文man

2011-08-24 14:28:47

DROP INDEX中文man

2011-08-24 14:10:10

DROP CAST中文man

2011-08-24 14:25:43

DROP GROUP中文man

2011-08-24 14:40:50

DROP RULE中文man

2011-08-24 10:59:19

CREATE DATA中文man

2011-08-24 15:03:08

drop_view中文man

2011-08-24 14:57:06

drop_type中文man

2011-08-24 14:49:13

drop_table中文man

2011-08-24 14:59:50

drop_user中文man

2011-08-24 14:43:21

drop_schema中文man

2011-08-24 14:38:16

DROP OPERAT中文man

2011-08-24 14:52:31

drop_trigge中文man

2011-08-24 14:46:42

drop_sequen中文man

2011-08-24 09:18:45

alter_datab中文man
点赞
收藏

51CTO技术栈公众号