Difference between revisions of "SYSTYPEINFO"

Latest revision as of 17:05, 22 December 2009

Description of all data types supported by the database

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

Column	Data Type	Width	Description
TYPE_NAME	C	30	Type name
DATA_TYPE	N	3	SQL data type
PRECISION	N	3	Maximum precision
LITERAL_PREFIX	C	1	Prefix used to quote a literal
LITERAL_SUFFIX	C	1	Suffix used to quote a literal
CREATE_PARAMS	C	30	Parameters used in creating the type
NULLABLE	N	1	Can you use NULL for this type?
CASE_SENSITIVE	L	1	Is it case sensitive?
SEARCHABLE	N	1	Can you use "WHERE" based on this type?
UNSIGNED_ATTRIBUTE	L	1	Is it unsigned?
FIXED_PREC_SCALE	L	1	Can it be a money value?
AUTO_INCREMENT	L	1	Can it be used for an auto-increment value?
LOCAL_TYPE	C	30	Localized version of type name
MINIMUM_SCALE	N	2	Minimum scale supported
MAXIMUM_SCALE	N	2	Maximum scale supported
SQL_DATA_TYPE	N	1	Reserved
SQL_DATETIME_SUB	N	1	Reserved
NUM_PREC_RADIX	N	2	Usually 2 or 10

SELECT * FROM systypeinfo

Recital, Recital Server

@@ Line 1: / Line 1: @@
-=SYSTYPEINFO=
-==Class==
-SQL Applications
 ==Purpose==
 Description of all data types supported by the database
@@ Line 62: / Line 55: @@
 ==Example==
 <code lang="recital">
-EXEC SQL
+SELECT * FROM systypeinfo
-SELECT *
-FROM systypeinfo;
 </code>
 ==Products==
-Recital Database Server, Recital Mirage Server, Recital Terminal Developer
+Recital, Recital Server
 [[Category:Documentation]]
 [[Category:SQL]]
 [[Category:System Tables]]