Okuzeka
Databases & SQL vocabulary · Tables, Schemas and Database Objects

CREATE TABLE

Meaning in databases & SQL, with examples

phraseCore term

In databases & SQL, CREATE TABLE means: The SQL statement that makes a new table, defining its name, its columns with their data types and its constraints such as the primary key.

In Turkish: tablo oluşturma komutu, CREATE TABLE

How it is used

Part of DDL. In real projects it lives in migration files rather than being typed by hand. Useful variants are CREATE TABLE IF NOT EXISTS and CREATE TABLE ... AS SELECT, which copies the result of a query into a new table.

Example sentences

  1. Paste the CREATE TABLE script here so I can see the column types.

  2. The migration failed because the CREATE TABLE ran twice; add IF NOT EXISTS.

Common collocations

  • CREATE TABLE statement
  • CREATE TABLE IF NOT EXISTS
  • CREATE TABLE AS SELECT
  • table definition
  • tableA structure in a relational database that stores data about one kind of thing in rows and columns, for example all customers or all orders.
  • ALTER TABLEThe SQL statement that changes the structure of an existing table, for example to add, rename or drop a column or to add a constraint.
  • DDLData definition language: the SQL statements that create, change and remove database objects, such as CREATE, ALTER and DROP.
  • data typeThe kind of value a column can hold, such as whole numbers, text, dates or true/false values. It controls what can be stored and how much space it takes.
  • migrationA versioned script that changes a database schema in a controlled way, or, more broadly, a project to move data from one database or system to another.

This word in other fields

The same English word can have a different meaning in another field:

More terms: Tables, Schemas and Database Objects

Practise with graded reading

Reading at the right level is the fastest way to make new words stick. Pick free English books by level: