SQL Server Management Studio - How to Create Local Database, Table & Add Data to It (Easy Tutorial)

I made this as I found a lot of the content out there over-complicated or missing key steps, so here is the beginner's guide I wanted for my beginner mind! Enjoy

The easy way to create a local db in SQL Server Management Studio and populate it with data.

Commands used:

• sqllocaldb create "VerbTables"

• sqllocaldb info "VerbTables"

• sqllocaldb start "VerbTables"

• To delete, use: sqllocaldb stop "VerbTables"

• To find your local db instances: Win+R (or just search Windows for 'run') then paste in: %LOCALAPPDATA%\Microsoft\Microsoft SQL Server Local DB\Instances\