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. |
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. |
Are you using SQL Anywhere at all?
"sp_help" makes me think of ASE or MS SQL Server...
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.
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.
Oh sorry. I must have clicked the wrong link. Too bad as what you suggested seemed pretty simple:-)