Convert a Datatype in to a Stringed List

Hi,

How do I convert a datatype into a list of properties?

Thanks
[i]edited by Will@decisions.com on 3/27/2019[/i]

Object Properties to Data Pairs < this is a awesome step! and yes exactly that!

You can get a list of properties and their types for any custom datatype by running:

use [DBname]
select
relationship_name as Property,
related_to_data_type as Type
from
defined_data_type_data_member
where data_structure = [namespace].[typename]
order by relationship_name asc