A data definition language or data description language (DDL) is a syntax similar to a computer programming language for defining data structures, especially database schemas.
A database is an organized collection of data, stored and accessed electronically.
A database trigger is procedural code that is automatically executed in response to certain events on a particular table or view in a database.
In the context of relational databases, a foreign key is a field (or collection of fields) in one table that uniquely identifies a row of another table or the same table.
In systems analysis, a many-to-many relationship is a type of cardinality that refers to the relationship between two entities A and B in which A may contain a parent instance for which there are many children in B and vice versa.
Referential integrity is a property of data stating references within it are valid.
A SQL result set is a set of rows from a database, as well as metadata about the query such as the column names, and the types and sizes of each column.
SQL (S-Q-L, "sequel"; Structured Query Language) is a domain-specific language used in programming and designed for managing data held in a relational database management system (RDBMS), or for stream processing in a relational data stream management system (RDSMS).
A table is a collection of related data held in a structured format within a database.
In SQL, the TRUNCATE TABLE statement is a (DDL) operation that marks the extents of a table for deallocation (empty for reuse).
A WHERE clause in SQL specifies that a SQL Data Manipulation Language (DML) statement should only affect rows that meet specified criteria.