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

Table

Meaning in databases & SQL, with examples

/ˈteɪbəl/nounCore term

In databases & SQL, table means: A structure in a relational database that stores data about one kind of thing in rows and columns, for example all customers or all orders.

In Turkish: tablo

How it is used

The main building block of a relational database. You create, alter, drop, truncate, join and query tables. Teams agree on naming rules, such as plural or singular table names (customers or customer) and snake_case.

Example sentences

  1. Order details are stored in a separate table called order_items.

  2. Who dropped the test table? My scripts are failing now.

Common collocations

  • create a table
  • drop a table
  • join two tables
  • lookup table
  • table name
  • rowOne horizontal line of a table, holding all the values for a single item, such as one customer or one order.
  • columnA vertical part of a table with a name and a data type, holding one kind of information for every row, such as email or created_at.
  • schemaThe structure of a database: its tables, columns, data types, keys and relationships. In some products it is also a named group of tables inside a database.
  • CREATE TABLEThe SQL statement that makes a new table, defining its name, its columns with their data types and its constraints such as the primary key.
  • 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.

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: