Create Database | Create Database Statement in SQL - sql - sql tutorial - learn sql




sql tutorial , pl sql tutorial , mysql tutorial , oracle tutorial , learn sql , sql server tutorial

Define Database Statement

  • The SQL CREATE DATABASE statement is used to create a new SQL database.
  • A database is a collection of organized data. A database is not the same as the Relational Database Management System (RDBMS).
  • An RDBMS can have one or multiple databases, whereas a database can only belong to one RDBMS.
  • On the other hand, a database can contain one or more tables, whereas a table can only belong to a database

How can we create database in SQL

  • Open Microsoft SQL Management Studio.
  • Connect to the database engine using database administrator credentials.
  • Expand the server node.
  • Right click Databases and select New Database.
  • Enter a database name and click on OK to create the database.
  • Create the database. From the MySQL command line, enter the command CREATE DATABASE
  • Display a list of your available databases.
  • Select your database.
  • Create a table.
  • Create an entry in the table.
  • Create more entries.
  • Run a query on your new database.

syntax

CREATE DATABASE "database_name";
  • If we want to create a database called " VEHICLES ", we would type in,
CREATE DATABASE VEHICLES;

Example:

  • If you want to create a new database , then the CREATE DATABASE statement would be as shown below −
                       SQL> CREATE DATABASE testDB;
  • Make sure you have the admin privilege before creating any database.
  • Once a database is created, you can check it in the list of databases as follows:
SQL> SHOW DATABASES;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| AMROOD             |
| WIKITECHY     |
| mysql              |
| orig               |
| test               |
| testDB             |
+--------------------+
7 rows in set (0.00 sec)

This tutorial provides more the basic needs and informations on sql tutorial , pl sql tutorial , mysql tutorial , sql server , sqlcode , sql queries , sql , sql formatter , sql join , w3schools sql , oracle tutorial , mysql , pl sql , learn sql , sql tutorial for beginners , sql server tutorial , sql query tutorial , oracle sql tutorial , t sql tutorial , ms sql tutorial , database tutorial , sql tutorial point , oracle pl sql tutorial , oracle database tutorial , oracle tutorial for beginners , ms sql server tutorial , sql tutorial pdf

Related Searches to Create Database Statement in SQL

Adblocker detected! Please consider reading this notice.

We've detected that you are using AdBlock Plus or some other adblocking software which is preventing the page from fully loading.

We don't have any banner, Flash, animation, obnoxious sound, or popup ad. We do not implement these annoying types of ads!

We need money to operate the site, and almost all of it comes from our online advertising.

Please add wikitechy.com to your ad blocking whitelist or disable your adblocking software.

×