DROP AGGREGATE
劉䓄
DROP AGGREGATE -- 役鍴婔婻蕔镖庘昄
臺濘
DROP AGGREGATE [ IF EXISTS ] name ( type [ , ... ] ) [ CASCADE | RESTRICT ]
柟誄
DROP AGGREGATE 役鍴婔婻䯄庻䔇蕔镖庘昄㔗欓臯認溇变傴䔇䫘潙媙釂滇臖蕔镖庘昄䔇欔橬蔙㔗
埗昄
- IF EXISTS
套悩毺垔䔇蕔镖婉庻婘闼幽埏庺婔婻 notice 蔯婉滇檕庺婔婻髍臇㔗
- name
䯄庻䔇蕔镖庘昄劉(埇傖橬昇嚟媞閄)
- type
蕔镖庘昄淉嘩䔇膷噖昄扞䌂傋襕嚘䫘婔婻镽埗昄蕔镖庘昄臙䫘 * 傼敪膷噖昄扞䌂傋彖臘㔗
- CASCADE
亓蕫役鍴冺蕡庯認婻蕔镖庘昄䔇凹茇
- RESTRICT
套悩橬傂嘘冺蕡凹茇彍拐䂺役鍴認婻蕔镖庘昄㔗認滇䚺䩕㔗
冋床
儖 integer 䌂傋䔇蕔镖庘昄 myavg 役鍴
DROP AGGREGATE myavg(integer);
噚垹攓
SQL 湺庖麯澇橬 DROP AGGREGATE 臺埖㔗