ictlwyu
asked on
Differences between 'DELETE DATABASE' & 'DROP DATABASE'?
What're the differences between using 'DELETE DATABASE' & 'DROP DATABASE' to delete a MS SQL database?
What is DELETE DATABASE? There is no such statement in ANSI SQL and MS SQL.
![Avatar of Guy Hengel [angelIII / a3]](https://filedb.experts-exchange.com/files/public/2013/11/25/ddbe0ea6-aa6e-4279-b781-57b735dd3ea0.jpeg){kind=small}
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
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
ASKER
Sorry! I meant using database 'DELETE' in Enterprise Manger and 'DROP DATABASE'.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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
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