Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 449
  • 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
What Kind of Coding Program is Right for You?

There are many ways to learn to code these days. From coding bootcamps like Flatiron School to online courses to totally free beginner resources. The best way to learn to code depends on many factors, but the most important one is you. See what course is best for you.

 
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

What Kind of Coding Program is Right for You?

There are many ways to learn to code these days. From coding bootcamps like Flatiron School to online courses to totally free beginner resources. The best way to learn to code depends on many factors, but the most important one is you. See what course is best for you.

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