Przełącznik języka
BUY COFFEE
If you like the website and want to support the project!
Tools
Mining
Security
CMS
Hardware
Backup
Windows Server
Uncategorised
useful sites
Databases
Emulators
Powershell
Storage Array
Active Directory
SEO
MSSQL
DNS
Antivirus program
Linux
Foto
Licznik
Visitor Info
- IP: 18.116.28.246
- Browser: Unknown
- Browser Version:
- Operating System: Unknown
Who Is Online
3
Online
Sunday, 19 May 2024 06:51
Using DROP DATABASE
Using DROP DATABASE
This command 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. This command cannot be executed while you or anyone else is connected to the target database (connect to postgres or any other database to issue this command).
Syntax
The syntax for DROP DATABASE is given below −
DROP DATABASE [ IF EXISTS ] name
Parameters
The table lists the parameters with their descriptions.
| S. No. | Parameter & Description |
|---|---|
| 1 |
IF EXISTS
Do not throw an error if the database does not exist. A notice is issued in this case. |
| 2 |
name The name of the database to remove. |
Example
The following is a simple example, which will delete testdb from your PostgreSQL schema −
postgres=# DROP DATABASE testdb;