DROP CAST

    Description

    will delete a previously defined cast. To be able to drop a cast, you must own the source or the target data type. These are the same privileges that are required to create a cast.

    IF EXISTS

    Do not throw an error if the cast does not exist. A notice is issued in this case.

    sourcetype

    targettype

    The name of the target data type of the cast.

    CASCADE

    RESTRICT

    Examples

    To drop the cast from type to type :

    There command conforms to the SQL standard.

    See Also

    CREATE CAST

    Parent topic: