DDL-Create

nThis statement is used to create a database or table

Syntax:

üCREATE DATABASE database_name

üCREATE TABLE table_name
(column_name1 data_type,column_name2 data_type,
column_name3 data_type,....)

Query:

üCREATE DATABASE Employee_db

üCREATE TABLE EMPtbl1 (EMPID int, EMPname varchar(255),
company varchar(255), salary varchar(255),
Location varchar(255))