View source for SYSCOLUMNCONSTRAINTS

==Purpose==
Description of the constraints for a table’s columns


==See Also==
[[SQL Data Types|DATA TYPES]], [[SQL SELECT|SELECT]], [[SQL System Tables|SYSTEM TABLES]]


==Description==
System Tables are system defined read-only tables. You can query these tables using the SELECT statement.


{| class="wikitable"
!Column||Data Type||Width||Description
|-
|TABLE_CAT||C||30||Table catalog
|-
|TABLE_SCHEM||C||30||Table schema
|-
|TABLE_NAME||C||30||Table name
|-
|COLUMN_NAME||C||32||Column name
|-
|CONSTRAINT_NAME||C||30||Constraint Name (see below)
|-
|CONSTRAINT||C||100||Constraint
|-
|}


Constraint names:

* AUTOINC NEXT
* AUTOINC STEP
* CALCULATED
* CHECK
* CHOICES
* DEFAULT
* ERROR
* HELP
* NOT NULL
* NULL SUPPORT
* PICTURE
* RANGE
* RECALCULATE
* WHEN


==Example==
<code lang="recital">
SELECT column_name;
  FROM syscolumnconstraints;
  WHERE table_name = 'example'
</code>


==Products==
Recital, Recital Server
[[Category:Documentation]]
[[Category:SQL]]
[[Category:System Tables]]