AgerNic.com
WEB DEVELOPER SITE, HTML, CSS, PHP, SQL

SQL DROP DataBase Statement


<< Previous Page
SQL tutorial
Next Page >>
SQL tutorial

SQL Tutorial » SQL DROP DataBase Statement

What is dropping database?

The DROP DATABASE statement is used to delete a specific existing SQL database.

Syntax:

DROP DATABASE database_name;
Note: You need to be careful before throwing away a database. Deleting a database from the server will loss the complete information stored in that database!

 

DROP DATABASE

How do I drop a MySQL database?

The following SQL statement drops the existing database "db_test":

DROP DATABASE db_test;

Related subjects:
SQL select data from DB SQL update DataBase PHP select / view data Conect to MySQLi SQL insert into table

 

Tags: sql drop: view, table, index, constraint, column, all tables, database, table if exists, foreign key, default constraint
sql drop database: if exists, close connections, in use, command, foece, where name lik, user, query
What is SQL DROP?
How do you DROP a value in SQL?
Is DROP the same as delete SQL?
What is DROP in database?
How do I drop a database in SQL Server?
What is drop database command in SQL?
What is dropping database?
How do I drop a MySQL database?

 

DROP DATABASE if exists

IF EXISTS is available in SQL Server 2016 (13.x). This command allows you to conditionally delete a database only if the database already exists. If you try to delete a non-existent database without specifying the IF EXISTS option, SQL Server will issue an error.

DROP DATABASE IF EXISTS db_test;

 

SQL DROP database in use

How do I drop a database that is currently in use?
How do I force drop a database in SQL Server?
Can not drop database because it is in use?
How do you drop a database if it exists in SQL?

The database disappear from the SQL Server 2005...:)

This works, but be careful, it will cause data loss to open transactions.

ALTER DATABASE[db_test]

 



sql drop: view, table, index, constraint, column, all tables, database, table if exists, foreign key, default constraint
sql drop database: if exists, close connections, in use, command, foece, where name lik, user, query
What is SQL DROP?
How do you DROP a value in SQL?
Is DROP the same as delete SQL?
What is DROP in database?
How do I drop a database in SQL Server?
What is drop database command in SQL?
What is dropping database?
How do I drop a MySQL database?
SQL DROP DataBase Statement - sql tutorial

Online Editor
ONLINE EDITOR

news templates


COLOR PICKER

news templates
This tool makes it easy to create, adjust, and experiment with custom colors for the web.


HTML Templates
news templates
Magnews2 is a modern and creative free magazine and news website template that will help you kick off your online project in style.


CSS HTML Layout
news templates
Find here examples of creative and unique website layouts.


Free CSS HTML Menu
news templates
Find here examples of creative and unique website CSS HTML menu.


Home - Database
SQL - Database
SQL Syntax
SQL Select Data
SQL Insert Data
SQL Update
SQL Delete Row
PHP mysqli_query()
SQL order
SQL Create Database
SQL Display Data
SQL Count()
SQL mysqli_connect
SQL create table
SQL Where And & Or
SQL like Syntax
SQL Between Operator
SQL IN Operator
Online Editor
ONLINE EDITOR

news templates


COLOR PICKER

news templates
This tool makes it easy to create, adjust, and experiment with custom colors for the web.


HTML Templates
news templates
Magnews2 is a modern and creative free magazine and news website template that will help you kick off your online project in style.


CSS HTML Layout
news templates
Find here examples of creative and unique website layouts.


Free CSS HTML Menu
news templates
Find here examples of creative and unique website CSS HTML menu.


jQuery replace...
jQuery replaceClass...
jQuery click ()...
jQuery switchClass()...
jQuery draggable()...
jQuery HTML...
jQuery scroll smooth...
jQuery scroll()...
jQuery stop()...
jQuery animate()...
jQuery SlideToggle()...
jQuery slideDown()...
jQuery slideUp()...
jQuery fadeToggle...
jQuery fadeOut()...
jQuery fadeIn()...
jQuery Effects - hide () and show ()...
jQuery Events...
jQuery Attributes...
jQuery Selectors...