Create table

SQL Create table

To create a table in a database you should use the SQL command CREATE TABLE.

SQL Create table syntax

CREATE TABLE table_name (column_name1 column_data_type, column_name2 column_data_type, …) ;

Create table example

CREATE TABLE lessons
(
ID INT PRIMARY KEY,
name VARCHAR(100) NOT NULL,
description VARCHAR(255)
);