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

FREE Online Google Play APK Downloader

Buy APP Installs, Buy 100% Genuine Installs