CREATE DATABASE
The CREATE query is used to create a database or objects such as tables, views, stored procedures, etc.
Creating a database: A Database is defined as a structured set of data. So, in SQL the very first step to store the data in a well structured manner is to create a database. The CREATE DATABASE statement is used to create a new database in SQL.
Syntax: CREATE DATABASE database_name;
database_name: name of the database.
CREATE DATABASE
The CREATE TABLE statement is used to create a new table in a database.
Syntax
CREATE TABLE table_name (
column1 datatype,
column2 datatype,
column3 datatype,
….
);
