Logo
Unionpedia
Communication
Get it on Google Play
New! Download Unionpedia on your Android™ device!
Download
Faster access than browser!
 

Check constraint

Index Check constraint

A check constraint is a type of integrity constraint in SQL which specifies a requirement that must be met by each row in a database table. [1]

14 relations: Column (database), Data integrity, Data validation, Database trigger, Isolation (database systems), Null (SQL), Predicate (mathematical logic), Relational database management system, Row (database), Select (SQL), SQL, Table (database), Update (SQL), Where (SQL).

Column (database)

In a relational database, a column is a set of data values of a particular simple type, one value for each row of the database.

New!!: Check constraint and Column (database) · See more »

Data integrity

Data integrity is the maintenance of, and the assurance of the accuracy and consistency of, data over its entire life-cycle, and is a critical aspect to the design, implementation and usage of any system which stores, processes, or retrieves data.

New!!: Check constraint and Data integrity · See more »

Data validation

In computer science, data validation is the process of ensuring data have undergone data cleansing to ensure they have data quality, that is, that they are both correct and useful.

New!!: Check constraint and Data validation · See more »

Database trigger

A database trigger is procedural code that is automatically executed in response to certain events on a particular table or view in a database.

New!!: Check constraint and Database trigger · See more »

Isolation (database systems)

In database systems, isolation determines how transaction integrity is visible to other users and systems.

New!!: Check constraint and Isolation (database systems) · See more »

Null (SQL)

Null (or NULL) is a special marker used in Structured Query Language to indicate that a data value does not exist in the database.

New!!: Check constraint and Null (SQL) · See more »

Predicate (mathematical logic)

In mathematical logic, a predicate is commonly understood to be a Boolean-valued function P: X→, called the predicate on X. However, predicates have many different uses and interpretations in mathematics and logic, and their precise definition, meaning and use will vary from theory to theory.

New!!: Check constraint and Predicate (mathematical logic) · See more »

Relational database management system

A relational database management system (RDBMS) is a database management system (DBMS) based on the relational model invented by Edgar F. Codd at IBM's San Jose Research Laboratory.

New!!: Check constraint and Relational database management system · See more »

Row (database)

In the context of a relational database, a row—also called a tuple—represents a single, implicitly structured data item in a table.

New!!: Check constraint and Row (database) · See more »

Select (SQL)

The SQL SELECT statement returns a result set of records from one or more tables.

New!!: Check constraint and Select (SQL) · See more »

SQL

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).

New!!: Check constraint and SQL · See more »

Table (database)

A table is a collection of related data held in a structured format within a database.

New!!: Check constraint and Table (database) · See more »

Update (SQL)

An SQL UPDATE statement changes the data of one or more records in a table.

New!!: Check constraint and Update (SQL) · See more »

Where (SQL)

A WHERE clause in SQL specifies that a SQL Data Manipulation Language (DML) statement should only affect rows that meet specified criteria.

New!!: Check constraint and Where (SQL) · See more »

Redirects here:

Check Constraint.

References

[1] https://en.wikipedia.org/wiki/Check_constraint

OutgoingIncoming
Hey! We are on Facebook now! »