Interview Question

What is CREATE TABLE?

CREATE TABLE defines a table, columns, types, and constraints.

💡 Concept ✅ Quick Revision 🗃️ SQL

Answer

CREATE TABLE defines a new table and its columns. • Each column receives a name and data type. • Table or column constraints can enforce valid data. • Creating a table does not automatically insert rows.

💡 SQL Example

CREATE TABLE teams (
  team_id integer PRIMARY KEY,
  name text NOT NULL UNIQUE
);

Result

CREATE TABLE

⚡ Quick Revision

CREATE TABLE defines a table, columns, types, and constraints.

←

PreviousDifference between DELETE, DROP, and TRUNCATE?

NextWhat is ALTER TABLE?

→