Enum storage in SQL

Does anyone know how Enums are stored in SQL? I want to create a view and display the caption value, but I am not seeing a table where the Enums are stored.