SQL CREATE TABLE Statement

SQL CREATE TABLE Statement

SQL CREATE TABLE Statement is used to create a new table in a database. Users can define the table structure by specifying the column’s name and data type in the CREATE TABLE command....

Syntax

To create a table in SQL, use this CREATE TABLE syntax:...

SQL CREATE TABLE Example

Let’s look at some examples of CREATE TABLE command in SQL and see how to create table in SQL....

Create Table From Another Table

We can also use CREATE TABLE to create a copy of an existing table. In the new table, it gets the exact column definition all columns or specific columns can be selected....

Important Points About SQL CREATE TABLE Statement

CREATE TABLE statement is used to create new table in a database. It defines the structure of table including name and datatype of columns. The DESC table_name; command can be used to display the structure of the created table We can also add constraint to table like NOT NULL, UNIQUE, CHECK, and DEFAULT. If you try to create a table that already exists, MySQL will throw an error. To avoid this, you can use the CREATE TABLE IF NOT EXISTS syntax....