Create Table


Prev Tutorial Next Tutorial

Create Table

Create Table statement is used for create a table in database. Tables are organized into rows and columns, and each table must have a name.

Syntax

	
CREATE TABLE table_name
(
column_name1 data_type(size),
column_name2 data_type(size),
column_name3 data_type(size),
....
);

Example

	
CREATE TABLE Employee 
(
emp_id number(5),
name varchar(20),
salary number(10),
);

Employee table

emp_idnamesalary
   

The empty table can be filled with data by using the INSERT INTO statement.


Prev Tutorial Next Tutorial

Advertisements




Download Projects

Advertisements

Download WhatsApp Status Video

Buy This Ad Space Only $50 per Month, Ad Size 300X250