<div>
We got some idea from your query though it is not completely fit with our situation.<br />
<br />
Now it is solved.<br />
<br />
Thanks.
</div>


We got some idea from your query though it is not completely fit with our situation.

Now it is solved.

Thanks.

<div>
<div class="content wysiwyg-content">
Which system tables in Sybase contain information about the based datatype of user-defined datatype?<br />
I know that we can use sp_help &lt;user-defined datatype name&gt; to get information about the based datatype.<br />
<br />
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.<br />
<br />
How can I do that?<br />
<br />
Thanks.
</div>
</div>


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?

Thanks.

How can I get the based data type of user-defined datatype in Sybase?

Sybase, a subsidiary of SAP, builds a client/server relational database management system. Products include Adaptive Server Enterprise (ASE), Adaptive Server Anywhere (ASA), Sybase Unwired Platform (SUP) for mobile applications, Afaria for enterprise mobile device management and IQ for data warehouse and big data applications.

Sybase Database

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.

Microsoft SQL Server

Databases are organized collections of data, most commonly accessed through management systems including schemas, tables, queries and processes that allow users to enter and manipulate the information or utilize it in other fashions, such as with web applications or for reporting purposes.