Create table

sql

CREATE TABLE users (
  user_id INTEGER PRIMARY KEY,
  email VARCHAR(255) NOT NULL UNIQUE,
  created_at TIMESTAMP NOT NULL
);

Explanation

Use explicit types and constraints to enforce data quality.

Learn the surrounding workflow

Compare similar commands or jump into common fixes when this command is part of a bigger troubleshooting path.

Same sheet · prioritizing CREATE, ALTER, and DROP

Modify an existing table by adding a new column.

Open In sheetsqlsame section

Remove a table definition and its data.

Open In sheetsqlsame section

Remove all rows quickly without dropping the table.

Open In sheetsqlsame section

Attach a foreign key or check constraint after table creation.

Open In sheetsqlsame section

Add an index to improve lookup performance.

Open In sheetsql1 tag match

Mark a column as the main row identifier.