Dropping a User-Defined Datatype

Drop a user-defined datatype to remove it from your database.

Prerequisites

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

In the Databases folder in Enterprise Explorer, under the database connection profile, expand the navigation tree for the appropriate database and schema owner.

Database	Steps
From an ASE connection profile	Expand the Databases folder. Expand the tree for a database and then the tree for the appropriate schema owner.
From a SQL Anywhere or Sybase IQ connection profile	Expand the tree for a database. Expand the Schemas folder and then the tree for the appropriate schema owner.

Under the User Defined Types folder, right-click the datatype you want to drop, and choose Drop.

Created June 25, 2009. Send feedback on this help topic to Sybase Technical Publications: pubs@sybase.com