# How to Create a Table in SQL?

SQL CREATE TABLE statement is used to create table in a database.

If you want to create a table, you should name the table and define its column and each column's data type.

Let's see the simple syntax to create the table.

`create table "tablename"`  

`("column1" "data type",`  

`"column2" "data type",`  

`"column3" "data type",`  

`...`  

`"columnN" "data type");`  

Let us take an example to create a STUDENTS table with ID as primary key and NOT NULL are the constraint showing that these fields cannot be NULL while creating records in the table.

`CREATE TABLE STUDENTS (`  

`ID INT      NOT NULL,`  

`NAME VARCHAR (20) NOT NULL,`  

`AGE INT       NOT NULL,`  

`ADDRESS CHAR (25),`  

`PRIMARY KEY (ID)`  

`);`

You can verify it, if you have created the table successfully by looking at the message displayed by the SQL Server, else you can use DESC command as follows:

SQL> DESC STUDENTS;

![](https://lh7-us.googleusercontent.com/k1udT3BDong0HPbxFtG72-1iJZpkvNYB4mLVbes6puXR3aLjna5OCkfIxoep4Wh6WnIBCbio2Dv1cWhi1oiD4aaf7c876uDe9ynogLZaNGq7OiQTcEX5sFLIFGyKwhGw5cjKkYcu9qgUU56DDtAqpm0 align="left")

Now you have the STUDENTS table available in your database and you can use to store required information related to students.