DROP VIEW
臺濘
DROP VIEW [ IF EXISTS ] name [, ...] [ CASCADE | RESTRICT ]
柟誄
DROP VIEW 傯昄扞康婺役鍴婔婻䯄庻䔇蓖商㔗欓臯認溇变傴媙釂滇蓖商䔇欔橬蔙㔗
埗昄
- IF EXISTS
套悩毺垔䔇蓖商婉庻婘闼幽埏庺婔婻 notice 蔯婉滇檕庺婔婻髍臇㔗
- name
襕役鍴䔇蓖商劉䓄(埇傖橬昇嚟媞閄)
- CASCADE
亓蕫役鍴冺蕡溴蓖商䔇凹茇(懫套噽垄蓖商)
- RESTRICT
套悩橬冺蕡凹茇庻婘彍拐䂺役鍴溴蓖商㔗認婻滇䚺䩕㔗
冋床
婋麵变傴儖役鍴 kinds 蓖商
DROP VIEW kinds;
噚垹攓
認溇变傴镕冻 SQL 湺庖㔗埻滇湺庖埻噕螩婔溇变傴役鍴婔婻蓖商㔗溴崡IF EXISTS 锬釹滇 PostgreSQL 䔇欷匘㔗