Create a SQL Server Database with SQLOPS

UPDATE: SQL Operations Studio (SQLOPS) has since been renamed to Azure Data Studio. The steps in this article remain the same though. In any case, I’ve also rewritten these steps (and included the equivalent screenshots) specifically for Azure Data Studio . See Create a SQL Server Database with Azure Data Studio.

Here, I explain how to use SQL Operations Studio (SQLOPS) to create a database in SQL Server.

In my case, I’m running SQL Server on a Mac (via a Docker container), but these instructions are generic and should work exactly the same way on Linux and Windows.

This tutorial assumes you already have SQLOPS installed on your machine, and you’ve connected to your SQL Server instance. If you don’t have SQLOPS installed on your machine, here are instructions for installing it on a Mac and connecting to SQL Server via Docker.  The SQLOPS installation is pretty straightforward (you install it just like any other software), so if you’re on Linux or Windows, you shouldn’t have any issues.

Continue reading

SQL CREATE DATABASE Syntax – Listed by DBMS

This article contains the SQL CREATE DATABASE syntax, as implemented by various database management systems (DBMSs). The syntax is listed exactly as each vendor has listed it on their website. Click on the applicable link to view more detail about the syntax for a particular vendor.

The DBMSs covered are MySQL, SQL Server, PostgreSQL, and Oracle Database.

Continue reading

How to Create a Database from a Script in MySQL

To create a database from a script in MySQL:

  1. Open a Query tab in MySQL Workbench
  2. Run a CREATE DATABASE or CREATE SCHEMA statement to create the database (example below)

This will create a new database.

Screenshot of SQL script that creates a database in MySQL
Example of an SQL script that creates a database with tables, columns etc. In this case, the script has just run and has created the “Music” database. You can see the tables and their columns open in the left navigation pane.

Continue reading

How to Create a Database in MySQL Workbench using the GUI

To create a database in the MySQL Workbench GUI:

  1. Click the “new schema” button on the MySQL Workbench toolbar
  2. Enter a schema name (database name) and its default collation and click Apply
  3. Review the SQL statement and click Apply

The database will now be created, and a message will display advising that the script was successful.

Continue reading

How to Create a Database in Access

In Microsoft Access 2013 & 2016, you can create a database straight from the Welcome screen or from the work area. You can create either a blank database, or a database from a template.

Create a Blank Database

From the Welcome Screen

When you first open Access, the Welcome screen is displayed. You can create your database straight from here.

  1. Click Blank desktop database
  2. Name the database at the prompt and click Create

Your new database will have one table called “Table1”. You can modify this table to your needs. You can also create new tables and other database objects.

Continue reading