Solved

Differences between 'DELETE DATABASE' & 'DROP DATABASE'?

Posted on 2004-09-08
6
437 Views
Last Modified: 2008-03-17
What're the differences between using 'DELETE DATABASE' & 'DROP DATABASE' to delete a MS SQL database?
0
Comment
Question by:ictlwyu
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
6 Comments
 
LVL 36

Expert Comment

by:Zyloch
ID: 12013534
Hi

Well, I don't think you use DELETE DATABASE. DROP DATABASE is to basically delete the database, but DELETE is mostly used for tables (maybe can be used for database, but in that case, should be same as DROP)

Regards,
Zyloch
0
 
LVL 12

Expert Comment

by:patrikt
ID: 12013643
What is DELETE DATABASE? There is no such statement in ANSI SQL and MS SQL.
0
 
LVL 143

Expert Comment

by:Guy Hengel [angelIII / a3]
ID: 12013898
I agree with above: M$SQL Server does not have a statement DELETE DATABASE
the same as it doesn't have a " SELECT * FROM * " to select all data from a database...
DELETE means delete data (table rows)
DROP means delete meta-data [+all the data contained] (table definition, index definition, database definition)

CHeers
0
Ransomware: The New Cyber Threat & How to Stop It

This infographic explains ransomware, type of malware that blocks access to your files or your systems and holds them hostage until a ransom is paid. It also examines the different types of ransomware and explains what you can do to thwart this sinister online threat.  

 

Author Comment

by:ictlwyu
ID: 12024322
Sorry! I meant using database 'DELETE' in Enterprise Manger and 'DROP DATABASE'.
0
 
LVL 143

Accepted Solution

by:
Guy Hengel [angelIII / a3] earned 100 total points
ID: 12024663
There is no difference between the DELETE menu for the database and the SQL statement DROP DATABASE, as the menu actually uses the SQL "DROP DATABASE"
CHeers
0
 
LVL 36

Expert Comment

by:Zyloch
ID: 12030719
Seems people understand DELETE better than DROP... sigh, people these days, always thinking dropped things can be fixed but that ultra top secret file you just deleted lays forgotten in the Recycle Bin lol
0

Featured Post

Microsoft Certification Exam 74-409

Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

The Delta outage: 650 cancelled flights, more than 1200 delayed flights, thousands of frustrated customers, tens of millions of dollars in damages – plus untold reputational damage to one of the world’s most trusted airlines. All due to a catastroph…
Recently we ran in to an issue while running some SQL jobs where we were trying to process the cubes.  We got an error saying failure stating 'NT SERVICE\SQLSERVERAGENT does not have access to Analysis Services. So this is a way to automate that wit…
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
Via a live example, show how to shrink a transaction log file down to a reasonable size.

688 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question