Difference between revisions of "SYSUDTS"

Latest revision as of 17:06, 22 December 2009

Description of the user-defined types (UDTs) defined in the schema

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

Column	Data Type	Width	Description
TYPE_CAT	C	30	Type catalog
TYPE_SCHEM	C	30	Type schema
TYPE_NAME	C	30	Type name
CLASS_NAME	C	30	Class name
DATA_TYPE	N	2	SQL data type
REMARKS	C	30	Comment describing type

SELECT * FROM sysudts

Recital, Recital Server

@@ Line 1: / Line 1: @@
-=SYSUDTS=
-==Class==
-SQL Applications
 ==Purpose==
 Description of the user-defined types (UDTs) defined in the schema
@@ 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]]
 ==Description==
 System Tables are system defined read-only tables. You can query these tables using the SELECT statement.
@@ Line 40: / Line 31: @@
 ==Example==
 <code lang="recital">
-EXEC SQL
+SELECT * FROM sysudts
-SELECT *
-FROM sysudts;
 </code>
 ==Products==
-Recital Database Server, Recital Mirage Server, Recital Terminal Developer
+Recital, Recital Server
 [[Category:Documentation]]
 [[Category:SQL]]
 [[Category:System Tables]]