Create Table

Advertisements

DCL Command in SQL Select Command in SQL

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.


DCL Command in SQL Select Command in SQL

Advertisements

Buy This Ad Space @$20 per Month, Ad Size 600X200 Contact on: hitesh.xc@gmail.com or 8076671483

Pure VPN Privide Lowest Price VPN Just @ $1.65. Per Month with Non Detected IP Lowest Price Non Detected IP VPN

Magenet is best Adsense Alternative here we earn $2 for single link, Here we get links ads. Magenet

Download Projects

Advertisements


Buy Websites 9999595223

Buy Fresh and Payment Receive Media.net Account with Website. Contact on: hitesh.xc@gmail.com or 9999595223 Try this Keyword C++ Programs