
SQL BASICS – How to Delete a Database
Press CTRL+N to open the new query window. Type into the new Query window. USE MasterDROP DATABASE KBTECHPRO If you get an error it’s because there are opened connections. run the following ALTER DATABASE [KBTECHPRO] SET SINGLE_USER WITH ROLLBACK IMMEDIATE;ALTER DATABASE [KBTECHPRO] SET MULTI_USER; What this does: Then run DROP DATABASE [KBTECHPRO]
Read MoreSQL BASICS – Create a Database & Tables
Download and Install SQL\SQL Expresshttps://www.microsoft.com/en-gb/download/details.aspx?id=101064 Download an Install SQL Server Management Studiohttps://aka.ms/ssmsfullsetup Connect to your SQL Installation with SQL Management Studio Sever Type: Database EngineServer Name: Enter your server name or select from the drop-down menuClick ‘Connect’ You will be connected to the Server. At this point, if you have not created any databases, you […]
Read More