October 2018
Beginner to intermediate
348 pages
10h
English
UDTs can have columns added to them. For instance, some addresses have two lines, so we can add an address2 column:
ALTER TYPE customer_address ADD address2 TEXT;
UDT columns can also be renamed with the ALTER command:
ALTER TYPE customer_address RENAME address2 TO street2;