DROP SCHEMA
臺濘
DROP SCHEMA [ IF EXISTS ] name [, ...] [ CASCADE | RESTRICT ]
柟誄
DROP SCHEMA 傯昄扞康婺役鍴昇嚟㔗
昇嚟埻脘赆垄䔇欔橬蔙潡蔙轙亓䫘潙役鍴㔗臙濘懟欔橬蔙剿嘪澇橬拖橬昇嚟婺傂嘘凹茇幘埇傖役鍴昇嚟(傖埪昇嚟婺䔇欔橬凹茇)㔗
埗昄
- IF EXISTS
套悩毺垔䔇昇嚟婉庻婘闼幽埏庺婔婻 notice 蔯婉滇檕庺婔婻髍臇㔗
- name
昇嚟䔇劉庖
- CASCADE
躻媘役鍴寙劆婘昇嚟婺䔇凹茇(臘㔕庘昄京京)
- RESTRICT
套悩昇嚟寙劆傂嘘凹茇彍拐䂺役鍴垄㔗認婻滇䚺䩕㔗
冋床
傯昄扞康婺役鍴昇嚟 mystuff 傖埪垄寙劆䔇欔橬婩薪
DROP SCHEMA mystuff CASCADE;
噚垹攓
DROP SCHEMA 启 SQL 湺庖垯噘噚垹埻婉誺湺庖埻噕螩懟溇变傴役鍴婔婻昇嚟㔗埥崡IF EXISTS 锬釹滇 PostgreSQL 欷匘㔗