Whenever we want to store our data into the database the initial step involves creating a table. The CREATE TABLE statement in SQL is used to create a new table. As already discussed, a table consists of rows and columns, while creating a new table we need to provide all the details like Table name, name of the columns, type of data to be stored in columns, size of the data etc.

SYNTAX

31.png
 

Where,

  • CREATE TABLE                               : keyword used to create a table in a database.

  • Tablename                                     : The name of the table which we are going to create.

  • Column1Name, Column2Name      : The name of the columns to be added to the table.

  • Datatypes                                      : Data types specify the type of data that should be used for a column.                 

          Ø  Example1                                                                : If a column called "Address", is to be used to hold addresses, then that column should have a "varchar" (variable-length character) data

 

       Ø   Example2                                                              : If a column called "CustomerId", is to be used to hold unique CustomerIds, then that column should have an "INT" (Integer) data type.

  • [NULL/NOTNULL]                           : A column can have NULL or NOTNULL Values; this can be specified whenever we are                                                                                                               creating a table. If we don't specify, SQL Server will take NULL as the default.

 

Let’s understand the concept of “Create Table” by creating a simple table Persons.

32.png

On executing this query, we get the following result set:

33.png
 

PRACTICE YOURSELF 

34.png

Want More SQL Deep Dives