 |  LoginProducts  SalesSupportDownloadsAbout |
| Home » Technical Support » ElevateDB Technical Support » Product Manuals » ElevateDB Version 2 SQL Manual » DDL Statements » DROP DATABASE |
DROP DATABASEDrops an existing database.
Syntax
Usage
Use this statement to drop a database.
Dropping a database will drop all tables and the entire catalog for the database specified. This means that all data and metadata for the database will be permanently deleted. However, you can keep the catalog and tables but remove the database from the configuration by specifying the KEEP CONTENTS clause.
Examples
Required Privileges
The current user must be granted the system-defined Administrators role in order to execute this statement. Please see the User Security topic for more information.
SQL 2003 Standard Deviations
This statement deviates from the SQL 2003 standard in the following ways:
Syntax
DROP DATABASE <Name> [KEEP CONTENTS]
Usage
Use this statement to drop a database.
Dropping a database will drop all tables and the entire catalog for the database specified. This means that all data and metadata for the database will be permanently deleted. However, you can keep the catalog and tables but remove the database from the configuration by specifying the KEEP CONTENTS clause.Examples
-- The following statement drops the Support database. DROP DATABASE "Support"
Required Privileges
The current user must be granted the system-defined Administrators role in order to execute this statement. Please see the User Security topic for more information.
SQL 2003 Standard Deviations
This statement deviates from the SQL 2003 standard in the following ways:
| Deviation | Details |
| Extension | This SQL statement is an ElevateDB extension. |
More Support Options
This web page was last updated on Thursday, November 16, 2023 at 10:39 AM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ?  E-mail us at info@elevatesoft.com |
