Drop a SQL Server Database


I'm developing with a local SQL Server database.  I'm working on data migrations, so I'm frequently running a migration, then dropping the db, and repeating

Question:  When I try to use datagrip to drop the db, it always fails, indicating that there are connections to the db.  However, the connection is Datagrip itself.  So right now, I have to close datagrip, and use another tool like sqlcmd or ssms to do it.  How do I drop db using Datagrip?

1 comment
Comment actions Permalink

Jeremy Marsch,

It could be a bit tricky.

You no need to close DataGrip. You just need to Close All Sessions for the database (see Services) and after that you can easily drop database.



Please sign in to leave a comment.