Loading lesson path

Learn/SQL/SQL References

SQL•SQL References

SQL DATABASE Keyword

Concept visual

SQL DATABASE Keyword

Pointer walk

two pointers

left=0

right=6

Start at both ends

DATABASE Keyword

❮ SQL Keywords

Create Database

The CREATE DATABASE

command is used is to create a new SQL database. The following SQL creates a database called "testDB":

Example

CREATE DATABASE testDB;

Tip:

Make sure you have admin privilege before creating any database. Once a database is created, you can check it in the list of databases with the following SQL command: SHOW DATABASES;

Drop Database

The DROP DATABASE

command is used is to delete an existing SQL database. The following SQL drops a database named "testDB":

Example

DROP DATABASE testDB;

Note:

Be careful before dropping a database. Deleting a database will result in loss of complete information stored in the database!

❮ SQL Keywords

SQL CREATE VIEW Keyword

SQL DEFAULT Keyword

Loading lesson path

Learn/SQL/SQL References

SQL•SQL References

SQL DATABASE Keyword

Concept visual

SQL DATABASE Keyword

Pointer walk

two pointers

left=0

right=6

Start at both ends

DATABASE Keyword

❮ SQL Keywords

Create Database

The CREATE DATABASE

command is used is to create a new SQL database. The following SQL creates a database called "testDB":

Example

CREATE DATABASE testDB;

Tip:

Make sure you have admin privilege before creating any database. Once a database is created, you can check it in the list of databases with the following SQL command: SHOW DATABASES;

Drop Database

The DROP DATABASE

command is used is to delete an existing SQL database. The following SQL drops a database named "testDB":

Example

DROP DATABASE testDB;

Note:

Be careful before dropping a database. Deleting a database will result in loss of complete information stored in the database!

❮ SQL Keywords

SQL CREATE VIEW Keyword

SQL DEFAULT Keyword

SQL DATABASE Keyword

SQL DATABASE Keyword

DATABASE Keyword

Previous

Next

Create Database

The CREATE DATABASE

Example

Tip:

Drop Database

The DROP DATABASE

Example

Note:

Previous

Next

SQL DATABASE Keyword

SQL DATABASE Keyword

DATABASE Keyword

Previous

Next

Create Database

The CREATE DATABASE

Example

Tip:

Drop Database

The DROP DATABASE

Example

Note:

Previous

Next