Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 447
  • 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
Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

 
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

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

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