思维导图备注
Apache Doris v0.11 Documentation
首页 AI助手 白天 夜间 BookChat 小程序 小程序 阅读
  • 书签 我的书签
  • 添加书签 添加书签 移除书签 移除书签

DROP DATABASE

 Github  来源:Apache 浏览 565 扫码 2020-09-05 20:49:35
  • DROP DATABASE
    • Description This statement is used to delete the database Grammar: DROP DATABASE [IF EXISTS] db_name;
    • example
    • keyword

    DROP DATABASE

    Description This statement is used to delete the database Grammar: DROP DATABASE [IF EXISTS] db_name;

    Explain: After executing DROP DATABASE for a period of time, the deleted database can be restored through the RECOVER statement. See RECOVER statement for details

    example

    1. Delete database db_test DROP DATABASE db_test;

    keyword

    DROP,DATABASE

    当前内容版权归 Apache 或其关联方所有,如需对内容或内容相关联开源项目进行关注与资助,请访问 Apache .
    上一篇:
    下一篇:
    • 书签
    • 添加书签 移除书签
    • Apache Doris v3.0 中文文档
    • Apache Doris v3.0 Documentation
    • Apache Doris v2.1 Documentation
    • Apache Doris v2.1 中文文档
    • Apache Doris v2.0 Documentation
    • Apache Doris v2.0 中文文档
    • Apache Doris v1.2 Documentation
    • Apache Doris v1.2 中文文档
    • Apache Doris v1.1 Documentation
    • Apache Doris v1.1 中文文档
    • Apache Doris v1.0 中文文档
    • Apache Doris v1.0 Documentation
    • Apache Doris v0.15 Documentation
    • Apache Doris v0.15 中文文档
    • Apache Doris v0.14 Documentation
    • Apache Doris v0.14 中文文档
    • Apache Doris v0.13 Document
    • Apache Doris v0.13 中文文档
    • Apache Doris 0.12 Documentation
    • Apache Doris 0.12 中文文档
    • Apache Doris v0.11 Documentation
    • Apache Doris v0.11 中文文档
    • Apache Doris 文档(201812)
    • Compilation and deployment
      • Compilation
        • Installation and deployment
          • Cluster upgrade
          • Getting started
            • Guidelines for Basic Use
              • Advanced Use Guide
                • Best Practices
                  • Data Partition
                    • Data Model, ROLLUP and Prefix Index
                    • Administrator Guide
                      • Load Data
                        • Introduction Overview
                          • Broker Load
                            • Stream load
                              • Routine Load
                                • Insert Into
                                • HTTP API
                                  • CANCEL LABEL
                                    • Compaction Action
                                      • get_log_file
                                        • GET LABEL STATE
                                          • RESTORE TABLET
                                          • Maintainence Operation
                                            • Metadata Operations and Maintenance
                                              • Monitoring and alarming
                                                • Multi-tenancy(Exprimental)
                                                  • Tablet metadata management tool
                                                    • Data replica management
                                                    • config
                                                      • Configuration
                                                      • Backup and Recovery
                                                        • Colocation Join
                                                          • Data export
                                                            • Authority Management
                                                              • File Manager
                                                                • Time zone
                                                                  • Variable
                                                                  • Extending Ability
                                                                    • Doris On ES
                                                                      • User Define Function
                                                                      • Design Documents
                                                                        • Doris Storage File Format Optimization
                                                                          • Metadata Design Document
                                                                          • SQL Manual
                                                                            • SQL Functions
                                                                              • Date Time Functions
                                                                                • current_timestamp
                                                                                  • date_add
                                                                                    • date_format
                                                                                      • date_sub
                                                                                        • datediff
                                                                                          • day
                                                                                            • dayname
                                                                                              • Dayofmonth
                                                                                                • dayofweek
                                                                                                  • Dayofyear
                                                                                                    • from_days
                                                                                                      • from_unixtime
                                                                                                        • month
                                                                                                          • Monthname
                                                                                                            • now
                                                                                                              • Strtodate
                                                                                                                • timediff
                                                                                                                  • to_days
                                                                                                                    • unix_timestamp
                                                                                                                      • utc_timestamp
                                                                                                                        • weekofyear
                                                                                                                          • year
                                                                                                                          • Sptial Functions
                                                                                                                            • ST_AsText,ST_AsWKT
                                                                                                                              • ST_Circle
                                                                                                                                • `ST_Contains’
                                                                                                                                  • ST_Distance_Sphere
                                                                                                                                    • ST_GeometryFromText,ST GeomFromText
                                                                                                                                      • ST_LineFromText,ST_LineStringFromText
                                                                                                                                        • St_Point’
                                                                                                                                          • ST_Polygon,ST_PolyFromText,ST_PolygonFromText
                                                                                                                                            • ST_X
                                                                                                                                              • ST_Y
                                                                                                                                              • String Functions
                                                                                                                                                • ASCII
                                                                                                                                                  • concat
                                                                                                                                                    • Concat_ws
                                                                                                                                                      • findinset
                                                                                                                                                        • getjsondouble
                                                                                                                                                          • getjsonint
                                                                                                                                                            • getjsonstring
                                                                                                                                                              • group_concat
                                                                                                                                                                • instr
                                                                                                                                                                  • lcase
                                                                                                                                                                    • left
                                                                                                                                                                      • length
                                                                                                                                                                        • locate
                                                                                                                                                                          • lower
                                                                                                                                                                            • lpad
                                                                                                                                                                              • ltrim
                                                                                                                                                                                • money_format
                                                                                                                                                                                  • regexp_extract
                                                                                                                                                                                    • regexp_replace
                                                                                                                                                                                      • repeat
                                                                                                                                                                                        • right
                                                                                                                                                                                          • split_part
                                                                                                                                                                                            • strleft
                                                                                                                                                                                              • strright
                                                                                                                                                                                              • Aggregate Functions
                                                                                                                                                                                                • BITMAP
                                                                                                                                                                                                  • COUNT_DISTINCT
                                                                                                                                                                                                    • COUNT
                                                                                                                                                                                                      • HLLUNIONAGG
                                                                                                                                                                                                        • MAX
                                                                                                                                                                                                          • MIN
                                                                                                                                                                                                            • NDV
                                                                                                                                                                                                              • PERCENTILE_APPROX
                                                                                                                                                                                                                • STDDEV,STDDEV_POP
                                                                                                                                                                                                                  • STDDEV_SAMP
                                                                                                                                                                                                                    • SUM
                                                                                                                                                                                                                      • VARIANCESAMP,VARIANCESAMP
                                                                                                                                                                                                                        • VARIANCE,VARPOP,VARIANCEPOP
                                                                                                                                                                                                                        • CAST
                                                                                                                                                                                                                        • DDL Statements
                                                                                                                                                                                                                          • Account Management
                                                                                                                                                                                                                            • CREATE ROLE
                                                                                                                                                                                                                              • CREATE USER
                                                                                                                                                                                                                                • DROP ROLE
                                                                                                                                                                                                                                  • DROP USER
                                                                                                                                                                                                                                    • Grant
                                                                                                                                                                                                                                      • REVOKE
                                                                                                                                                                                                                                        • SET PASSWORD
                                                                                                                                                                                                                                          • SET PROPERTY
                                                                                                                                                                                                                                            • SHOW GRANTS
                                                                                                                                                                                                                                              • SHOW ROLES
                                                                                                                                                                                                                                              • Administration
                                                                                                                                                                                                                                                • ADMIN CANCEL REPAIR
                                                                                                                                                                                                                                                  • ADMIN CHECK TABLET
                                                                                                                                                                                                                                                    • ADMIN REPAIR
                                                                                                                                                                                                                                                      • ADMIN SET CONFIG
                                                                                                                                                                                                                                                        • ADMIN SET REPLICA STATUS
                                                                                                                                                                                                                                                          • ADMIN SHOW CONFIG
                                                                                                                                                                                                                                                            • ADMIN SHOW REPLICA DISTRIBUTION
                                                                                                                                                                                                                                                              • ADMIN SHOW REPLICA STATUS
                                                                                                                                                                                                                                                                • ALTER CLUSTER
                                                                                                                                                                                                                                                                  • ALTER SYSTEM
                                                                                                                                                                                                                                                                    • CANCEL DECOMMISSION
                                                                                                                                                                                                                                                                      • CREATE CLUSTER
                                                                                                                                                                                                                                                                        • CREATE FILE
                                                                                                                                                                                                                                                                          • DROP CLUSTER
                                                                                                                                                                                                                                                                            • DROP FILE
                                                                                                                                                                                                                                                                              • ENTER
                                                                                                                                                                                                                                                                                • LINK DATABASE
                                                                                                                                                                                                                                                                                  • MIGRATE DATABASE
                                                                                                                                                                                                                                                                                    • SHOW BACKENDS
                                                                                                                                                                                                                                                                                      • SHOW BROKER
                                                                                                                                                                                                                                                                                        • SHOW FILE
                                                                                                                                                                                                                                                                                          • SHOW FRONTENDS
                                                                                                                                                                                                                                                                                            • SHOW FULL COLUMNS
                                                                                                                                                                                                                                                                                              • SHOW MIGRATIONS
                                                                                                                                                                                                                                                                                                • SHOW TABLE STATUS
                                                                                                                                                                                                                                                                                                • Data Definition
                                                                                                                                                                                                                                                                                                  • ALTER DATABASE
                                                                                                                                                                                                                                                                                                    • ALTER TABLE
                                                                                                                                                                                                                                                                                                      • ALTER VIEW
                                                                                                                                                                                                                                                                                                        • BACKUP
                                                                                                                                                                                                                                                                                                          • CANCEL ALTER
                                                                                                                                                                                                                                                                                                            • CANCEL BACKUP
                                                                                                                                                                                                                                                                                                              • CANCEL RESTORE
                                                                                                                                                                                                                                                                                                                • Colocate Join
                                                                                                                                                                                                                                                                                                                  • CREATE DATABASE
                                                                                                                                                                                                                                                                                                                    • CREATE REPOSITORY
                                                                                                                                                                                                                                                                                                                      • CREATE TABLE
                                                                                                                                                                                                                                                                                                                        • CREATE VIEW
                                                                                                                                                                                                                                                                                                                          • CREATE FUNCTION
                                                                                                                                                                                                                                                                                                                            • DROP DATABASE
                                                                                                                                                                                                                                                                                                                              • DROP REPOSITORY
                                                                                                                                                                                                                                                                                                                                • DROP TABLE
                                                                                                                                                                                                                                                                                                                                  • DROP VIEW
                                                                                                                                                                                                                                                                                                                                    • DROP FUNCTION
                                                                                                                                                                                                                                                                                                                                      • HLL
                                                                                                                                                                                                                                                                                                                                        • RECOVER
                                                                                                                                                                                                                                                                                                                                          • RESTORE
                                                                                                                                                                                                                                                                                                                                            • SHOW FUNCTION
                                                                                                                                                                                                                                                                                                                                              • TRUNCATE TABLES
                                                                                                                                                                                                                                                                                                                                              • Data Manipulation
                                                                                                                                                                                                                                                                                                                                                • BROKER LOAD
                                                                                                                                                                                                                                                                                                                                                  • CANCEL DELETE
                                                                                                                                                                                                                                                                                                                                                    • CANCEL LOAD
                                                                                                                                                                                                                                                                                                                                                      • DELETE
                                                                                                                                                                                                                                                                                                                                                        • EXPORT
                                                                                                                                                                                                                                                                                                                                                          • GET LABEL STATE
                                                                                                                                                                                                                                                                                                                                                            • INSERT
                                                                                                                                                                                                                                                                                                                                                              • LOAD
                                                                                                                                                                                                                                                                                                                                                                • MINI LOAD
                                                                                                                                                                                                                                                                                                                                                                  • MULTI LOAD
                                                                                                                                                                                                                                                                                                                                                                    • PAUSE ROUTINE LOAD
                                                                                                                                                                                                                                                                                                                                                                      • RESTORE TABLET
                                                                                                                                                                                                                                                                                                                                                                        • RESUME ROUTINE LOAD
                                                                                                                                                                                                                                                                                                                                                                          • ROUTINE LOAD
                                                                                                                                                                                                                                                                                                                                                                            • SHOW ALTER
                                                                                                                                                                                                                                                                                                                                                                              • SHOW BACKUP
                                                                                                                                                                                                                                                                                                                                                                                • SHOW DATA
                                                                                                                                                                                                                                                                                                                                                                                  • SHOW DATABASES
                                                                                                                                                                                                                                                                                                                                                                                    • SHOW DELETE
                                                                                                                                                                                                                                                                                                                                                                                      • SHOW EXPORT
                                                                                                                                                                                                                                                                                                                                                                                        • SHOW LOAD
                                                                                                                                                                                                                                                                                                                                                                                          • SHOW PARTITIONS
                                                                                                                                                                                                                                                                                                                                                                                            • SHOW PROPERTY
                                                                                                                                                                                                                                                                                                                                                                                              • SHOW REPOSITORIES
                                                                                                                                                                                                                                                                                                                                                                                                • SHOW RESTORE
                                                                                                                                                                                                                                                                                                                                                                                                  • SHOW ROUTINE LOAD TASK
                                                                                                                                                                                                                                                                                                                                                                                                    • SHOW ROUTINE LOAD
                                                                                                                                                                                                                                                                                                                                                                                                      • SHOW SNAPSHOT
                                                                                                                                                                                                                                                                                                                                                                                                        • SHOW TABLES
                                                                                                                                                                                                                                                                                                                                                                                                          • SHOW TABLET
                                                                                                                                                                                                                                                                                                                                                                                                            • SHOW TRANSACTION
                                                                                                                                                                                                                                                                                                                                                                                                              • STOP ROUTINE LOAD
                                                                                                                                                                                                                                                                                                                                                                                                                • STREAM LOAD
                                                                                                                                                                                                                                                                                                                                                                                                                • Data Types
                                                                                                                                                                                                                                                                                                                                                                                                                  • BIGINT
                                                                                                                                                                                                                                                                                                                                                                                                                    • BOOLEAN
                                                                                                                                                                                                                                                                                                                                                                                                                      • CHAR
                                                                                                                                                                                                                                                                                                                                                                                                                        • date
                                                                                                                                                                                                                                                                                                                                                                                                                          • DATETIME
                                                                                                                                                                                                                                                                                                                                                                                                                            • DECIMAL
                                                                                                                                                                                                                                                                                                                                                                                                                              • Double
                                                                                                                                                                                                                                                                                                                                                                                                                                • FLOAT
                                                                                                                                                                                                                                                                                                                                                                                                                                  • INT
                                                                                                                                                                                                                                                                                                                                                                                                                                    • SMALLINT
                                                                                                                                                                                                                                                                                                                                                                                                                                      • TINYINT
                                                                                                                                                                                                                                                                                                                                                                                                                                        • VARCHAR
                                                                                                                                                                                                                                                                                                                                                                                                                                        • Utility
                                                                                                                                                                                                                                                                                                                                                                                                                                          • Describe
                                                                                                                                                                                                                                                                                                                                                                                                                                      • Apache Community
                                                                                                                                                                                                                                                                                                                                                                                                                                        • Gitter Manual
                                                                                                                                                                                                                                                                                                                                                                                                                                          • Contribute to Doris
                                                                                                                                                                                                                                                                                                                                                                                                                                            • PMC Members & Committer
                                                                                                                                                                                                                                                                                                                                                                                                                                              • Code Submission Guide
                                                                                                                                                                                                                                                                                                                                                                                                                                                • Publish of Apache Doris
                                                                                                                                                                                                                                                                                                                                                                                                                                                  • Subscribe to mailing lists
                                                                                                                                                                                                                                                                                                                                                                                                                                                    • Verify Apache Release
                                                                                                                                                                                                                                                                                                                                                                                                                                                    暂无相关搜索结果!

                                                                                                                                                                                                                                                                                                                                                                                                                                                      本文档使用 BookStack 构建

                                                                                                                                                                                                                                                                                                                                                                                                                                                      文章二维码

                                                                                                                                                                                                                                                                                                                                                                                                                                                      手机扫一扫,轻松掌上读

                                                                                                                                                                                                                                                                                                                                                                                                                                                      文档下载

                                                                                                                                                                                                                                                                                                                                                                                                                                                      • 普通下载
                                                                                                                                                                                                                                                                                                                                                                                                                                                      • 下载码下载(免登录无限下载)
                                                                                                                                                                                                                                                                                                                                                                                                                                                      你与大神的距离,只差一个APP
                                                                                                                                                                                                                                                                                                                                                                                                                                                      APP下载
                                                                                                                                                                                                                                                                                                                                                                                                                                                      请下载您需要的格式的文档,随时随地,享受汲取知识的乐趣!
                                                                                                                                                                                                                                                                                                                                                                                                                                                      PDF文档 EPUB文档 MOBI文档
                                                                                                                                                                                                                                                                                                                                                                                                                                                      温馨提示 每天每在网站阅读学习一分钟时长可下载一本电子书,每天连续签到可增加阅读时长
                                                                                                                                                                                                                                                                                                                                                                                                                                                      下载码方式下载:免费、免登录、无限制。 免费获取下载码

                                                                                                                                                                                                                                                                                                                                                                                                                                                      微信小程序阅读

                                                                                                                                                                                                                                                                                                                                                                                                                                                      BookChat 微信小程序阅读
                                                                                                                                                                                                                                                                                                                                                                                                                                                      您与他人的薪资差距,只差一个随时随地学习的小程序

                                                                                                                                                                                                                                                                                                                                                                                                                                                      书签列表

                                                                                                                                                                                                                                                                                                                                                                                                                                                        阅读记录

                                                                                                                                                                                                                                                                                                                                                                                                                                                        阅读进度: 0.00% ( 0/0 ) 重置阅读进度

                                                                                                                                                                                                                                                                                                                                                                                                                                                          欢迎使用AI助手 AI助手
                                                                                                                                                                                                                                                                                                                                                                                                                                                          全屏 缩小 隐藏 清空