Create Table in SQL

Create table in SQL: How to create table in SQL

In this post , i'm going to explain that how you can create table in SQL easily:

To create table in SQL, you can use CREATE Table command:

Syntax for Create table:

CREATE TABLE Table_Name( Column _Name1 Datatype, Column_Name2 Datatype.....etc);

In above, to create table, First you need to define the action about what you are going to create so i have define command CREATE TABLE, this command will always be used if you are going to create Table.
Then you need to give Table Name because every table must have their unique name.

Then create column name like First_Name, Lasr_Name, Age whatever you required then every column must have their datatype define so that SQL can identify what type of values will be passed.

Now look at below example:
In this we are going to create a table for employee record like EMP table haveEmp_ID, Emp_Name, Emp_Age, DOJ and Salary.

CREATE TABLE EMP
(Emp_ID INT, 
 Emp_Name Varchar(20),
 Emp_Age INT, 
 Emp_Salary INT);

Result will be :

Emp_ID

Emp_Name

Emp_Age

Emp_Salay

This is the way by which you can create SQL Table. To Insert Value in this table, please refer Insert Values post in next post.