Difference between revisions of "SYSCOLUMNCONSTRAINTS"

Latest revision as of 16:15, 22 December 2009

Description of the constraints for a table’s columns

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

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:

SELECT column_name;
  FROM syscolumnconstraints;
  WHERE table_name = 'example'

Recital, Recital Server

@@ Line 1: / Line 1: @@
-=SYSCOLUMNCONSTRAINTS=
-==Class==
-SQL Applications
 ==Purpose==
 Description of the constraints for a table’s columns
@@ Line 11: / Line 4: @@
 ==See Also==
-[[DATA TYPES]], [[SQL SELECT|SELECT]], [[SYSTEM TABLES]]
+[[SQL Data Types|DATA TYPES]], [[SQL SELECT|SELECT]], [[SQL System Tables|SYSTEM TABLES]]
@@ Line 34: / Line 27: @@
 |-
 |}
 Constraint names:
@@ Line 55: / Line 49: @@
 ==Example==
 <code lang="recital">
-EXEC SQL
+SELECT column_name;
-SELECT column_name
+  FROM syscolumnconstraints;
-FROM syscolumnconstraints
+  WHERE table_name = 'example'
-WHERE table_name = ’example’;
 </code>
 ==Products==
-Recital Database Server, Recital Mirage Server, Recital Terminal Developer
+Recital, Recital Server
 [[Category:Documentation]]
 [[Category:SQL]]
 [[Category:System Tables]]