CREATE TABLE

The CREATE TABLE statement is used to create new Table in Database. by using this Table we can store data in table.

Syntax For SQL:

CREATE TABLE employee ( Emp_id INT(50) NOT NULL, Name VARCHAR(100), Surname VARCHAR(100), Salary DEC(50), Dept_id INT(50) NOT NULL );

After Execution: 
(1 row(s) affected)
(0 ms taken)