How To Create Table Using Query In SQL

In this article, we will learn how to create a Table using SQL query.

To create a new table in a database, the CREATE TABLE statement is used.

Syntax

CREATE TABLE TABLE_NAME (
    column1 datatype,
    column2 datatype,
    ....
    columnN datatype
);

The column parameters are used to specify the names of the columns of the table.

The datatype parameter is used to specify the type of data the column can hold (e.g. integer, varchar, date, etc.).

Example

The subsequent statement would create a table called “Article” with four columns.

CREATE TABLE Article (
    ID int,
    Title varchar(100),
    Author varchar(100),
    Views int 
);

The ID and Views columns are of type int and will hold an integer value.

The Title and Author columns are of type varchar and will hold characters value, and the maximum length for these fields is 100 characters.

Also, check How To Use Comments In SQL