DocHero
Lesson 28 +10 XP

CREATE TABLE

The CREATE TABLE statement creates a new table and defines its columns and their data types.

Syntax


sql

### CREATE TABLE Persons (

### PersonID int,

### LastName varchar(255),

### FirstName varchar(255),

### City varchar(255)
);
  • Each column has a name and a data type.
  • int stores whole numbers.
  • varchar(255) stores text up to 255 characters.

Create a table from another table


sql

### CREATE TABLE NewTable AS

### SELECT * FROM OldTable;

Copies both the structure and the data.

Common data types

TypeStores
intwhole numbers
decimal(p,s)exact decimal numbers
varchar(n)variable-length text
char(n)fixed-length text
datedate (YYYY-MM-DD)
datetimedate and time
booleantrue / false

TL;DR

  • CREATE TABLE defines columns and types.
  • Each column needs a name and a data type.
  • varchar(255) is the common text type.
  • int stores whole numbers, date stores dates.