Database Language
Database Definition Language Schema
Column Constraint
Primary Key Foreign Key

 

A set of rules and symbols used for communication and expression. A collection of data organized in a structured manner.
A logical representation of the structure of a database. A language used to define and manipulate the structure and organization of a database.
A rule that restricts the values allowed in certain columns or tables. A vertical part of a table that holds a specific type of data.
A field in one table that refers to the primary key in another table. A unique identifier for each record in a table.

 

SQL DDL
Data Manipulation Language CREATE TABLE
ALTER TABLE DROP TABLE
TRUNCATE TABLE ADD COLUMN

 

Data Definition Language, a subset of SQL used to define and modify the structure of database objects. Structured Query Language, a popular database language used to manipulate and retrieve data.
A DDL query used to create a new table in a database. A subset of SQL that allows manipulation of data stored in a database, including inserting, updating, and deleting records.
A DDL query used to delete a table from a database. A DDL query used to modify the structure of an existing table.
A DDL query used to add a new column to an existing table. A DDL query used to remove all the data from a table while keeping its structure intact.

 

DROP COLUMN RENAME TABLE

 

A DDL query used to change the name of an existing table. A DDL query used to remove a column from an existing table.