SQL Drop Database

using SQL DROP statement on sql database

DROP statement is used to remove a database.

MySQL and PostgreSQL

Syntax:
DROP {DATABASE | SCHEMA} [IF EXISTS] db_name
Drop database example:
DROP DATABASE IF EXISTS customerdb;

This will remove the database 'customerdb' if it exists.

SQL server

Syntax:
DROP DATABASE  db_name
Drop database example:
DROP DATABASE  customerdb;

This will remove the database 'customerdb' .

© 2010 by Finnesand Data. All rights reserved.
This site aims to provide FREE programming training and technics.
Finnesand Data as site owner gives no warranty for the correctness in the pages or source codes.
The risk of using this web-site pages or any program codes from this website is entirely at the individual user.