PostgreSQL 8.2.3 婺桺桺懼
劯锔媆锔媆誕嬉誕

DROP FUNCTION

劉䓄

DROP FUNCTION -- 役鍴婔婻庘昄

臺濘

DROP FUNCTION [ IF EXISTS ] name ( [ [ argmode ] [ argname ] argtype [, ...] ] )
    [ CASCADE | RESTRICT ]

柟誄

DROP FUNCTION 儖役鍴婔婻䯄庻䔇庘昄㔗襕欓臯認溇变傴䫘潙媙釂滇庘昄䔇欔橬蔙㔗媙釂弄滯庘昄䔇埗昄䌂傋啹婺庹婻婉劯䔇庘昄埇脘嚔橬劯湙䔇劉庖启婉劯䔇埗昄彖臘㔗

埗昄

IF EXISTS

套悩毺垔䔇庘昄婉庻婘闼幽埏庺婔婻 notice 蔯婉滇檕庺婔婻髍臇㔗

name

䯄庻䔇庘昄劉䓄(埇傖橬昇嚟媞閄)

argmode

埗昄䔇昇嚟IN(䚺䩕), OUT, INOUT 㔗臙濘懟 DROP FUNCTION 垂鍙婪幽婉濘懟 OUT 埗昄啹婺彴桺庘昄䔇躆傘埻驔襕膷噖埗昄㔗啹溴彖庺 IN 启 INOUT 埗昄儌轿崘庖㔗

argname

埗昄䔇劉庖㔗臙濘懟 DROP FUNCTION 垂鍙婪幽婉濘懟埗昄䔇劉庖啹婺彴桺庘昄䔇躆傘埻驔襕膷噖埗昄䔇昄扞䌂傋㔗

argtype

套悩橬䔇臺滇庘昄埗昄䔇䌂傋(埇傖䫘昇嚟媞閄)

CASCADE

亓蕫役鍴冺蕡庯庘昄䔇凹茇(懫套淉嘩严潡蓥埏単)

RESTRICT

套悩橬傂嘘冺蕡凹茇庻婘彍拐䂺役鍴臖庘昄㔗認婻滇䚺䩕㔗

冋床

認溇变傴役鍴广桹湹庘昄

DROP FUNCTION sqrt(integer);

噚垹攓

SQL 湺庖麯垔幬庖婔婻 DROP FUNCTION 臺埖㔗嘖启認溇变傴婉噚垹㔗

埽蓕

CREATE FUNCTION, ALTER FUNCTION
劯锔饡釕嬉誕
DROP DOMAIN婪婔亓DROP GROUP