• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 452
  • Last Modified:

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

What're the differences between using 'DELETE DATABASE' & 'DROP DATABASE' to delete a MS SQL database?
0
ictlwyu
Asked:
ictlwyu
1 Solution
 
ZylochCommented:
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
 
patriktCommented:
What is DELETE DATABASE? There is no such statement in ANSI SQL and MS SQL.
0
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
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
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

 
ictlwyuAuthor Commented:
Sorry! I meant using database 'DELETE' in Enterprise Manger and 'DROP DATABASE'.
0
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
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
 
ZylochCommented:
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: Microsoft Windows 7 Basic

This introductory course to Windows 7 environment will teach you about working with the Windows operating system. You will learn about basic functions including start menu; the desktop; managing files, folders, and libraries.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now