-
Notifications
You must be signed in to change notification settings - Fork 127
UDTs
martinjw edited this page Feb 26, 2023
·
2 revisions
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.