LocalDB: How do you delete it?

Question

Setup: Entity framework code first to new database.

Scenario: I'm playing around with EF and I add a bunch of elements to my database. I then change the entity model, and while I know that I could do migrations, I just want to start from scratch and basically wipe the database from the earth.

The database used by default was (localdb)\v11.0.

My question is:

Can I go somewhere and just delete a file, or start some kind of manager to delete that database and start from scratch?

+1 This is a good an interesting question to start working with EF. — Will Marcouiller, Mar 12 '13 at 10:41

score 70 · Answer 1 · edited Apr 19 '16 at 15:29

70

Just go in command prompt with admin rights and type:

//list the instancies
sqllocaldb i

//stop selected instance
sqllocaldb p "selected instance"

//delete
sqllocaldb d "selected instance"

//recreate or create new one 
sqllocaldb c "new instance"

edited Apr 19 '16 at 15:29

BartoszKP

34,786
15
102
130

answered Jan 12 '14 at 10:45

Filip Gjorgjevikj

1,367
13
11

4

Deleting the instance does not delete the actual database file. When EF recreates it the existing MDF file is (sometimes) reused. – MEMark Sep 17 '14 at 16:15
1

Awesome, thanks. That should be the accepted answer. Regarding the previous comment: That's a program call 'file explorer' becomes handy ;-) – Anytoe Nov 25 '15 at 18:57

Mohamed Salah Darwish · Answer 2 · 2014-02-03T23:38:56.797

26

From Visual Studio => Click View => SQL Server Object Explorer=> Right click the desired database and choose delete and it will be deleted or do whatever you want

edited Feb 03 '14 at 23:38

answered Feb 03 '14 at 23:26

Mohamed Salah Darwish

361
3
4

2

You delete the connection to the database, not the database itself – Eldar Jan 30 '20 at 06:33

score 18 · Answer 3 · edited Mar 31 '21 at 12:07

18

If you're using Entity Framework Core, you can enter this in the Package Manager Console:

PM> Drop-Database

It will drop the current database. This command will tell you which one:

PM> Get-DbContext

This is also handy:

PM> Get-Help about_EntityFrameworkCore

Instead of the Package Manager Console, you can also use the dotnet CLI via PowerShell or the command prompt:

PS> dotnet ef database drop

Make sure you install the EF extension first by running this command:

dotnet tool install --global dotnet-ef

edited Mar 31 '21 at 12:07

officer

2,080
1
20
29

answered Nov 07 '17 at 02:10

Matt Gregory

8,074
8
33
40

2

This is exactly what I was looking for. – Victorio Berra Dec 21 '17 at 15:58

score 7 · Answer 4 · answered Mar 10 '13 at 04:18

7

I think you want to delete an individual database, not a LocalDB instance. If so, just issue a drop database command:

DROP DATABASE databasename;

You can do this from sqlcmd, Management Studio, your application code, maybe even Visual Studio...

answered Mar 10 '13 at 04:18

Aaron Bertrand

272,866
37
466
490

CRice · Answer 5 · 2020-07-22T06:37:25.373

There's an exe called SqlLocalDB.exe which can be found in C:\Program Files\Microsoft SQL Server\{version}\Tools\Binn

For a full delete:

>sqllocaldb stop InstanceName
>sqllocaldb delete InstanceName

Once that is done, you can optionally also remove the .mdf files from the disk. Mine were at

C:\Users\{username}

You can also recreate a fresh instance, and even attach the .mdf files you still want afterwards.

>sqllocaldb create InstanceName
>sqllocaldb start InstanceName
>sqllocaldb info InstanceName

You can see your instances at:

C:\Users\{username}\AppData\Local\Microsoft\Microsoft SQL Server Local DB\Instances

score 4 · Answer 6 · answered Apr 18 '17 at 07:57

Yes you can. In VS 2015/2017 press Ctrl+Q, type "object explorer". The "SQL Server Object Explorer" should open, where you'll see your local DB instances. Expand the DB instance, and you'll see the different databases. Select one database perform a right click and choose "Delete".

For additional information check this link.

Hope that helps.

score 2 · Answer 7 · edited Mar 30 '21 at 17:26

2

With Entity Framework Core, this can also be accomplished form the the command line:

dotnet ef database drop --project [path to project]

Or if you have multiple database contexts:

dotnet ef database drop --project [path to project] --context [ContextName]

Make sure you install the EF extension first by running this command:

dotnet tool install --global dotnet-ef

edited Mar 30 '21 at 17:26

officer

2,080
1
20
29

answered May 21 '20 at 11:17

Mike Godin

3,727
3
27
29

score 1 · Answer 8 · answered Mar 16 '16 at 23:58

LocalDB is its own separate server (its name suggests that it is just a database in some other server instance but this is not the case). In SQL Server 2014 Express you connect to it using server name "(localdb)\MSSQLLocalDB", just as you would connect to any ordinary database server. If you connect using SQL Server Management Studio then you have all the power of SSMS available to you.

score 0 · Answer 9 · answered May 22 '20 at 03:44

0

Entity Framework 3.1:

Drop Database

dotnet ef database drop

Do not want to drop database, willing to delete tables in the database

dotnet ef database update 0

answered May 22 '20 at 03:44

Nick B

249
1
4
11

score 0 · Answer 10 · answered May 26 '21 at 13:57

I wrote a batch file to delete an SQL local db. It uses trusted connection. If you want, you can add your credentials with -U Username -P Password parameters.

Check out sqlcmd documentation!

@echo off
set /p DbName=Enter local db name:
echo.
sqlcmd -e -S "(LocalDb)\MSSQLLocalDB" -d "master" -Q "EXEC msdb.dbo.sp_delete_database_backuphistory @database_name = N'%DbName%'; USE [master]; DROP DATABASE [%DbName%];"
echo Finished!
pause > nul

score 0 · Answer 11 · answered Mar 22 '23 at 16:08

if you are having the following error:

FormatMessageW failed. Error code returned: 15100

or

FormatMessageW failed. Error code returned: 15105

check to make sure you are using the right version of sqllocaldb.exe

You can verify the version using:

where.exe sqllocaldb
C:\Program Files\Microsoft SQL Server\150\Tools\Binn\SqlLocalDB.exe
C:\Program Files\Microsoft SQL Server\130\Tools\Binn\SqlLocalDB.exe

depending on the order you install sql server, the newer version could be later in the path and it will report the error above.

LocalDB: How do you delete it?

11 Answers11

Linked