| ADD COLUMN |
A DDL query used to add a new column to an existing table. |
| ALTER TABLE |
A DDL query used to modify the structure of an existing table. |
| CREATE TABLE |
A DDL query used to create a new table in a database. |
| Column |
A vertical part of a table that holds a specific type of data. |
| Constraint |
A rule that restricts the values allowed in certain columns or tables. |
| DDL |
Data Definition Language, a subset of SQL used to define and modify the structure of database objects. |
| DROP COLUMN |
A DDL query used to remove a column from an existing table. |
| DROP TABLE |
A DDL query used to delete a table from a database. |
| Data Manipulation Language |
A subset of SQL that allows manipulation of data stored in a database, including inserting, updating, and deleting records. |
| Database |
A collection of data organized in a structured manner. |
| Database Definition Language |
A language used to define and manipulate the structure and organization of a database. |
| Foreign Key |
A field in one table that refers to the primary key in another table. |
| Language |
A set of rules and symbols used for communication and expression. |
| Primary Key |
A unique identifier for each record in a table. |
| RENAME TABLE |
A DDL query used to change the name of an existing table. |
| SQL |
Structured Query Language, a popular database language used to manipulate and retrieve data. |
| Schema |
A logical representation of the structure of a database. |
| TRUNCATE TABLE |
A DDL query used to remove all the data from a table while keeping its structure intact. |
