• September 29, 2014
  • SQL
  • Comments Off on SQL CREATE Table

SQL CREATE Table

Table:

A table in SQL is a set of data which is systematically displayed in rows and columns.

The CREATE TABLE Statement is used to create a new table.

Syntax:

CREATE TABLE tableName
(columnName1 datatype,
columnName2 datatype,
...
 
columnNameN datatype);

Example:

CREATE TABLE EMPLOYEE (
 
EMP_ID INT NOT NULL,
 
NAME VARCHAR (20) NOT NULL,
 
AGE INT NOT NULL,
 
SALARY INT NOT NULL,
 
PRIMARY KEY (EMP_ID)
 
);

Output:

Table created.

Note: We can use DESC command to see the created table.

DESC EMPLOYEE;

Table	 Column	 Data Type	Length	Precision	Scale	Primary Key	Nullable	Default	Comment
EMPLOYEE EMP_ID	 Number		-	   -		  0	   1	           -                   -
 	 NAME	 Varchar	20	   -		  0	   -	           -                   -
 	 AGE	 Number		-	   -		  0	   -	           -                   -
 	 SALARY	 Number		-	   -		  0	   -               -                   -

 
Next Topic: SQL ALTER Table with example.
Previous Topic: SQL DROP Database with example.

Related Topics:

How to build java project using ant in eclipse?
JAXB marshalling – convert java object to xml example.
How to create pdf file in java using iText jar?
Generics class example.
OGNL in struts 2.
Hibernate One-to-One Mapping using xml.
Send inline image in email using JavaMail API.
Quartz 2 JobListener example.

 


Comments are closed.