1DROP CAST()                      SQL Commands                      DROP CAST()
2
3
4

NAME

6       DROP CAST - remove a cast
7
8

SYNOPSIS

10       DROP CAST [ IF EXISTS ] (sourcetype AS targettype) [ CASCADE | RESTRICT ]
11
12

DESCRIPTION

14       DROP CAST removes a previously defined cast.
15
16       To  be  able to drop a cast, you must own the source or the target data
17       type. These are the same privileges that are required to create a cast.
18

PARAMETERS

20       IF EXISTS
21              Do not throw an error if the cast does not exist.  A  notice  is
22              issued in this case.
23
24       sourcetype
25              The name of the source data type of the cast.
26
27       targettype
28              The name of the target data type of the cast.
29
30       CASCADE
31
32       RESTRICT
33              These  key  words  do  not  have  any effect, since there are no
34              dependencies on casts.
35

EXAMPLES

37       To drop the cast from type text to type int:
38
39       DROP CAST (text AS int);
40
41

COMPATIBILITY

43       The DROP CAST command conforms to the SQL standard.
44

SEE ALSO

46       CREATE CAST [create_cast(7)]
47
48
49
50SQL - Language Statements         2008-06-08                       DROP CAST()