Although types are best managed using Composer, DQL may be the only option for certain needs, such as defining key constraints for a type. Types can be manipulated with DQL using
CREATE TYPE, ALTER TYPE, and
DROP TYPE statements. These statements are discussed briefly in this section.
CREATE TYPE statement creates a new custom type. For example, the following DQL query creates a custom type named
dq_loan_doc, which has
dq_document as its supertype:
CREATE TYPE dq_loan_doc (account_id STRING(10)) WITH SUPERTYPE dq_document
It is also possible to specify data dictionary information in the
CREATE TYPE statement including value assistance, mapping table, default values for attributes, and type-level and attribute-level ...