Create a Custom SQL Enum Type

InstructorTyler Clark

Share this video with your friends

Send Tweet

Data integrity is critical to scaling and working with large datasets. One additional way to keep this integrity is to define custom types like enums. In this lesson we’ll create and assign data to a custom enum type.

For more info:

  • https://www.postgresql.org/docs/9.2/sql-createtype.html
  • https://docs.oracle.com/cd/A91202_01/901_doc/server.901/a88856/c14ordb.htm#433046
  • https://www.c-sharpcorner.com/article/user-defined-table-types-and-table-valued-parameters/