Creating a Table

Snippet

The CREATE TABLE statement is used to create a new table in a database. You must define the name of the columns and their data types.

snippet.sql
sql
CREATE TABLE users (
    id INTEGER,
    username VARCHAR(50)
);

Breakdown

id INTEGER,

Defines a column named 'id' that stores whole numbers.

username VARCHAR(50)

Defines a column named 'username' that stores text up to 50 characters.

From your library