Query: drop_cast
OS: suse
Section: 7
Format: Original Unix Latex Style Formatted with HTML and a Horizontal Scroll Bar
DROPCAST(7) SQL Commands DROP CAST(7)NAMEDROP CAST - remove a castSYNOPSISDROP CAST [ IF EXISTS ] (sourcetype AS targettype) [ CASCADE | RESTRICT ]DESCRIPTIONDROP CAST removes 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.PARAMETERSIF EXISTS Do not throw an error if the cast does not exist. A notice is issued in this case. sourcetype The name of the source data type of the cast. targettype The name of the target data type of the cast. CASCADE RESTRICT These key words do not have any effect, since there are no dependencies on casts.EXAMPLESTo drop the cast from type text to type int: DROP CAST (text AS int);COMPATIBILITYThe DROP CAST command conforms to the SQL standard.SEE ALSOCREATE CAST [create_cast(7)] SQL - Language Statements 2010-05-14 DROP CAST(7)