Skip to main content

create database

SQL Create Database Statement

Besides creating the database from the DBMS software like Oracle, MyQL, Microsoft Access etc. We can also create database with the query language. It is as simple as writing a SELECT, INSERT, UPDATE, DELETE Statement.

Creating a database using query language is very useful if for example you deploy your application to a computer that doesn’t have a database yet.

We can create a new database with the following syntax

SQL Create Database Syntax

How to Create Database in SQL Server 2005 Express Edition

In this tutorial you will learn how to create a Database in SQL Server 2005 Express Edition. The name of the database that we are going to create is “LibSys” which stands for Library System.

Note that I am using SQL Server Management Studio that is bundled with SQL Server 2008 R2. Regardless of version that you are using the environment still looks the same.

Please follow the steps below to create a database.