SQL CREATE Statement

An SQL CREATE statement is used to CREATE a table in Database.
Let us imagine an SQL TABLE with the following structure.

The SQL Create command to create the above table structure is as shown below:

CREATE TABLE EMPLOYEE(
		EMPLOYEE_ID INT NOT NULL,
		EMPLOYEE_NAME VARCHAR(50) NOT NULL,
		EMPLOYEE_DESIGNATION VARCHAR(50),
		PRIMARY KEY(EMPID),
		FOREIGN KEY(DEPARTMENTID) REFERENCES DEPARTMENT(DEPARTMENTID);
		);

Explanation: The above statement created a table called EMPLOYEE.
It setup the columns EMPLOYEE_ID as a primary key.
It setup EMPLOYEE_NAME as a NOT NULL column, making it mandatory.
It setup EMPDESIGNATION. A Foreign key DEPARTMENTID is created as reference to DEPARTMENT table.