Structured type

The SQL:1999 standard introduced a number of object–relational database features into SQL, chiefly among them structured user-defined types, usually called just structured types. These can be defined either in plain SQL with CREATE TYPE but also in Java via SQL/JRT. SQL structured types allow single inheritance.

Structured types are supported to varying degrees in Oracle Database, IBM Db2, PostgreSQL and Microsoft SQL Server, although the latter only allows structured types defined in CLR.