Difference between revisions of "SYSUDTS"

Revision as of 04:17, 25 October 2011

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

Revision as of 13:06, 22 December 2009 (view source) Yvonnemilne (Talk)	Revision as of 04:17, 25 October 2011 (view source) Yvonne.milne (Talk \| contribs) m (1 revision: SQL) Newer edit →
(No difference)