Editing a SQL Anywhere or Sybase IQ User-Defined Datatype

View a user-defined datatype in the User-Defined Type Editor.

Prerequisites

Before you view a user-defined datatype, be sure the data server that contains the user-defined datatype is running and that you created and established a connection to the data server.

In the Databases folder in Enterprise Explorer, under the database connection profile, expand the tree for a database, expand the Schemas folder and then the tree for the appropriate schema owner.
Expand the User Defined Types folder, right-click the user-defined datatype, and select Edit.

View the user-defined datatype properties.

Note: These properties are read-only for SQL Anywhere and Sybase IQ user-defined datatypes.

Editor Tab	Description
General	The user-defined datatype name appears in the Name field. The system datatype setting appears in the System Datatype field. The a null setting appears in the Null Value Setting field. The default appears in the Default Value field. Any check constraint for data of this datatype is shown in the Check Constraint field.
DDL	View the DDL for the user-defined datatype (read-only).