>>-CREATE ROW TYPE--row_type------------------------------------>
 
>--+---------------------------------+--+------------------+---><
   |                         (1)     |  '-UNDER--supertype-'
   '-(--| Field Definition |-------)-'
 

1. See Field Definition

The CREATE ROW TYPE statement declares a named ROW data type and registers it in the system catalog. You can assign a named ROW data type to a table or view to create a typed table or typed view. You can also define a column as a named ROW type. Although you can assign a ROW type to a table to define the schema of the table, ROW data types are not the same as table rows. Table rows consist of one or more columns; ROW data types consist of one or more fields, defined using the Field Definition syntax.

A named ROW data type is valid in most contexts where you can specify a data type. Named ROW types are said to be strongly typed. No two named ROW types are equivalent, even if they are structurally equivalent.

ROW types without identifiers are called unnamed ROW types. Any two unnamed ROW types are considered equivalent if they are structurally equivalent. For more information, see ROW Data Types.

Privileges on named ROW type columns are the same as privileges on any column. For more information, see Table-Level Privileges. (To see what privileges you have on a column, check the syscolauth system catalog table, which is described in the IBM Informix Guide to SQL: Reference.)