Drop a SQL Server Database

Answered

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.

 

0

Please sign in to leave a comment.