Which system tables in Sybase contain information about the based datatype of user-defined datatype?
I know that we can use sp_help <user-defined datatype name> to get information about the based datatype.
What I want is I would like to retrieve the based-datatype of user-defined datatype using SELECT statement by myself? systypes table contain datatype information including user-defined datatype of all the fields in the tables. But it doesn't contaion the based-dataype of user-defined data type.
How can I do that?