How do I get the base primitive data type of a UDT

[Former Member]

I know I can use sp_help <datatypename> to get information on a UDT. However is there a way for me to get the base primitive data type through SQL. Querying systypes doesn't seem to give me anything unique to get the primitive type that was used during creation.

[VolkerBarth]

Are you using SQL Anywhere at all?

"sp_help" makes me think of ASE or MS SQL Server...

[Former Member]

Yes it is ASE and v15. This system view is exactly what I am looking for however for some reason I don't have that view (actually I have very system views for some reason). This is a test machine so they may have been dropping views for some odd reason in some of their tests. I'll verify that but this suggestions looks like it will help me. Thanks.

[VolkerBarth]

This is a forum for SQL Anywhere, not ASE. Both are completely different database products. Therefore I would suggest to have a look at on one of Sybase's ASE newsgroups - see http://www.sybase.com/detail?id=1012843.

[Former Member]

Oh sorry. I must have clicked the wrong link. Too bad as what you suggested seemed pretty simple:-)

[VolkerBarth]

What version are you using?

v12 has introduced the "base_type_str" field in the "SYSUSERTYPE" system view:

select type_name, base_type_str, * from sysusertype

For older versions, you might need to build such a value based on joining SYSUSERTYPE with SYSDOMAIN.