Use this statement to remove a datatype from the database.
DROP DATATYPE datatype-name
Use the IF EXISTS clause if you do not want an error returned when the DROP statement attempts to remove a database object that does not exist.
It is recommended that you use DROP DOMAIN rather than DROP DATATYPE, as DROP DOMAIN is the syntax used in the ANSI/ISO SQL3 draft. You cannot drop system-defined data types (such as MONEY or UNIQUEIDENTIFIERSTR) from a database.
Any user who owns the object, or has DBA authority, can execute the DROP DATATYPE statement.
Automatic commit. Clears the Results tab in the Results pane in Interactive SQL.
SQL/2003 Core feature.
Drop MyDatatype from the database. If the datatype does not exist, an error is returned.
DROP DATATYPE MyDatatype;
|Discuss this page in DocCommentXchange.
Send feedback about this page using email.
|Copyright © 2009, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.1|