What is the difference between TYPE and DOMAIN in SQL

Question

I was wondering what is the difference between CREATE TYPE and CREATE DOMAIN in SQL? Anyone can help me on this subject?

Answer 1

With CREATE DOMAIN you can create a subtype that is based on one existing type (adding constraints to it).

With CREATE TYPE you can create composite types or enum or others that they are structurally different to existing types.