You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
martinjw edited this page Feb 26, 2023
·
2 revisions
User Defined Types
Many SQL databases provide one or more kinds of User Defined Types. With v2.8, the schema reader reads the following types:
User defined type (also known as a "domain types" in PostgreSql). It is a data type that is based on another underlying type.
User defined table types. These are table-like structures with typed attributes, often used for passing into stored procedures or return values from functions.
The support is basic, and there are important limitations:
Limited support for DDL generation (database scripting, migration, compare, code generation).
No support for complex UDT types. Among the things not supported: SqlServer allows Rules to be attached to UDTs (although rules are now deprecated), Oracle ADTs can define type bodies with methods as well as types.