Difference between revisions of "SQL Constraints"

From Lianjapedia
Jump to: navigation, search
m (1 revision: SQL)
 
(16 intermediate revisions by 3 users not shown)
Line 1: Line 1:
 
==Purpose==
 
==Purpose==
 
To define rules that help to provide data integrity
 
To define rules that help to provide data integrity
−
 
  
 
==See Also==
 
==See Also==
−
[[ALTER TABLE]], [[CREATE TABLE]], [[GRANT]], [[REVOKE]]
+
[[ALTER TABLE]], [[CREATE TABLE]], [[GRANT]], [[Lianja MetaData API]], [[REVOKE]], [[MetaData Editor|Working with MetaData]]
−
 
+
  
 
==Description==
 
==Description==
Line 12: Line 10:
 
====Table Constraints====
 
====Table Constraints====
  
−
 
+
{| class="wikitable" width="100%"
−
{| class="wikitable"
+
|[[CHECK Table Constraint|CHECK]]
−
|[[CHECK Table Constraint|CHECK]]||[[ERROR Table Constraint|ERROR]]||[[FOREIGN KEY Table Constraint|FOREIGN KEY]]
+
 
|-
 
|-
−
|[[INDEX Table Constraint|INDEX]]||[[KEY Table Constraint|KEY]]||[[ONCLOSE Table Constraint|ONCLOSE]]
+
|[[ERROR Table Constraint|ERROR]]
 
|-
 
|-
−
|[[ONDELETE Table Constraint|ONDELETE]]||[[ONINSERT Table Constraint|ONINSERT]]||[[ONOPEN Table Constraint|ONOPEN]]
+
|[[FOREIGN KEY Table Constraint|FOREIGN KEY]]
 
|-
 
|-
−
|[[ONROLLBACK Table Constraint|ONROLLBACK]]||[[ONUPDATE Table Constraint|ONUPDATE]]||[[PRIMARY KEY Table Constraint|PRIMARY KEY]]
+
|[[INDEX Table Constraint|INDEX]]
 
|-
 
|-
−
|[[UNIQUE Table Constraint|UNIQUE]]||||
+
|[[KEY Table Constraint|KEY]]
 +
|-
 +
|[[ONAFTERDELETE Table Constraint|ONAFTERDELETE]]
 +
|-
 +
|[[ONAFTERINSERT Table Constraint|ONAFTERINSERT]]
 +
|-
 +
|[[ONAFTERUPDATE Table Constraint|ONAFTERUPDATE]]
 +
|-
 +
|[[ONCLOSE Table Constraint|ONCLOSE]]
 +
|-
 +
|[[ONBEFOREDELETE Table Constraint|ONBEFOREDELETE]] / [[ONDELETE Table Constraint|ONDELETE]]
 +
|-
 +
|[[ONBEFOREINSERT Table Constraint|ONBEFOREINSERT]] / [[ONINSERT Table Constraint|ONINSERT]]
 +
|-
 +
|[[ONOPEN Table Constraint|ONOPEN]]
 +
|-
 +
|[[ONBEFOREUPDATE Table Constraint|ONBEFOREUPDATE]] / [[ONUPDATE Table Constraint|ONUPDATE]]
 +
|-
 +
|[[PRIMARY KEY Table Constraint|PRIMARY KEY]]
 +
|-
 +
|[[UNIQUE Table Constraint|UNIQUE]]
 
|-
 
|-
 
|}
 
|}
−
 
  
 
====Column Constraints====
 
====Column Constraints====
  
−
 
+
{| class="wikitable" width="100%"
−
{| class="wikitable"
+
|[[AUTO_INCREMENT Column Constraint|AUTO_INCREMENT]]
−
|[[AUTO_INCREMENT Column Constraint|AUTO_INCREMENT]]||[[AUTOINC Column Constraint|AUTOINC]]||[[CALCULATED Column Constraint|CALCULATED]]
+
 
|-
 
|-
−
|[[CHECK Column Constraint|CHECK]]||[[DEFAULT Column Constraint|DEFAULT]]||[[DESCRIPTION Column Constraint|DESCRIPTION]]
+
|[[AUTOSUGGESTIONS Column Constraint|AUTOSUGGESTIONS]]
 
|-
 
|-
−
|[[ERROR Column Constraint|ERROR]]||[[FOREIGN KEY Column Constraint|FOREIGN KEY]]||[[NOCPTRANS Column Constraint|NOCPTRANS]]
+
|[[AUTOSUGGESTIONHEADERS Column Constraint|AUTOSUGGESTIONHEADERS]]
 
|-
 
|-
−
|[[NOT NULL Column Constraint|NOT NULL]]||[[NULL Column Constraint|NULL]]||[[PRIMARY KEY Column Constraint|PRIMARY KEY]]
+
|[[AUTOINC Column Constraint|AUTOINC]]
 
|-
 
|-
−
|[[RANGE Column Constraint|RANGE]]||[[RECALCULATE Column Constraint|RECALCULATE]]||[[REFERENCES Column Constraint|REFERENCES]]
+
|[[CALCULATED Column Constraint|CALCULATED]]
 
|-
 
|-
−
|[[SET CHECK Column Constraint|SET CHECK]]||[[UNIQUE Column Constraint|UNIQUE]]||
+
|[[CHECK Column Constraint|CHECK]]
 +
|-
 +
|[[CHECKUNIQUE Column Constraint|CHECKUNIQUE]]
 +
|-
 +
|[[CHOICES Column Constraint|CHOICES]]
 +
|-
 +
|[[DEFAULT Column Constraint|DEFAULT]]
 +
|-
 +
|[[DESCRIPTION Column Constraint|DESCRIPTION]]
 +
|-
 +
|[[ERROR Column Constraint|ERROR]]
 +
|-
 +
|[[FOREIGN KEY Column Constraint|FOREIGN KEY]]
 +
|-
 +
|[[GETDATAMAPPING Column Constraint|GETDATAMAPPING]]
 +
|-
 +
|[[HELP Column Constraint|HELP]]
 +
|-
 +
|[[NOCPTRANS Column Constraint|NOCPTRANS]]
 +
|-
 +
|[[NOT NULL Column Constraint|NOT NULL]]
 +
|-
 +
|[[NULL Column Constraint|NULL]]
 +
|-
 +
|[[PICTURE Column Constraint|PICTURE]]
 +
|-
 +
|[[PRIMARY KEY Column Constraint|PRIMARY KEY]]
 +
|-
 +
|[[RANGE Column Constraint|RANGE]]
 +
|-
 +
|[[RECALCULATE Column Constraint|RECALCULATE]]
 +
|-
 +
|[[REFERENCES Column Constraint|REFERENCES]]
 +
|-
 +
|[[SET CHECK Column Constraint|SET CHECK]]
 +
|-
 +
|[[SETDATAMAPPING Column Constraint|SETDATAMAPPING]]
 +
|-
 +
|[[UNIQUE Column Constraint|UNIQUE]]
 
|-
 
|-
 
|}
 
|}
  
−
 
−
==Products==
 
−
Recital, Recital Server
 
 
[[Category:Documentation]]
 
[[Category:Documentation]]
 
[[Category:SQL|Constraints]]
 
[[Category:SQL|Constraints]]
 
[[Category:Reference]]
 
[[Category:Reference]]
 +
[[Category:Database Triggers]]
 +
[[Category:Metadata API]]

Latest revision as of 04:39, 1 July 2020

Purpose

To define rules that help to provide data integrity

See Also

ALTER TABLE, CREATE TABLE, GRANT, Lianja MetaData API, REVOKE, Working with MetaData

Description

A constraint is used to define rules that help to provide data integrity. There are two different types of constraints, TABLE constraints, which do not require any column information and column constraints, which are specific to the column name specified. You must have ALTER privilege on the table. The table will be locked for EXCLUSIVE use during the operation.

Table Constraints

CHECK
ERROR
FOREIGN KEY
INDEX
KEY
ONAFTERDELETE
ONAFTERINSERT
ONAFTERUPDATE
ONCLOSE
ONBEFOREDELETE / ONDELETE
ONBEFOREINSERT / ONINSERT
ONOPEN
ONBEFOREUPDATE / ONUPDATE
PRIMARY KEY
UNIQUE

Column Constraints

AUTO_INCREMENT
AUTOSUGGESTIONS
AUTOSUGGESTIONHEADERS
AUTOINC
CALCULATED
CHECK
CHECKUNIQUE
CHOICES
DEFAULT
DESCRIPTION
ERROR
FOREIGN KEY
GETDATAMAPPING
HELP
NOCPTRANS
NOT NULL
NULL
PICTURE
PRIMARY KEY
RANGE
RECALCULATE
REFERENCES
SET CHECK
SETDATAMAPPING
UNIQUE
Retrieved from "https://www.lianja.com/doc/index.php?title=SQL_Constraints&oldid=23436"