Returning information about a structured type

You can use built-in functions to return the name, schema, or internal type ID of a particular type.

Example

The following statement returns the exact type of the address value associated with the employee named 'Iris':

   SELECT TYPE_NAME(Address)
      FROM Employee
      WHERE Name='Iris';