forked from docs/doc-exports
luhuayi
177cd61a57
Reviewed-by: Pruthi, Vineet <vineet.pruthi@t-systems.com> Co-authored-by: luhuayi <luhuayi@huawei.com> Co-committed-by: luhuayi <luhuayi@huawei.com>
38 lines
4.8 KiB
HTML
38 lines
4.8 KiB
HTML
<a name="EN-US_TOPIC_0000001811634509"></a><a name="EN-US_TOPIC_0000001811634509"></a>
|
|
|
|
<h1 class="topictitle1">DROP EXCEPT RULE</h1>
|
|
<div id="body0000001384780045"><div class="section" id="EN-US_TOPIC_0000001811634509__s26b72b1858a44a5984f0fa6d9a84a67c"><h4 class="sectiontitle">Function</h4><p id="EN-US_TOPIC_0000001811634509__ae0128647c2ba4636aa6dfcf1ca144d9a">This syntax deletes a specified exception rule set.</p>
|
|
</div>
|
|
<div class="section" id="EN-US_TOPIC_0000001811634509__sa59cc6cc8a984fd197fefdd1473b4d11"><h4 class="sectiontitle">Precautions</h4><p id="EN-US_TOPIC_0000001811634509__ac7442e4e9fb44c3fbc73c718a3dc12ce">Only the system administrator can perform the <strong id="EN-US_TOPIC_0000001811634509__b2219106103514">DROP EXCEPT RULE</strong> operation.</p>
|
|
</div>
|
|
<div class="section" id="EN-US_TOPIC_0000001811634509__s3f9d958138244c4385543e5644eb82e6"><h4 class="sectiontitle">Syntax</h4><div class="codecoloring" codetype="Sql" id="EN-US_TOPIC_0000001811634509__s226ab8de9c9b4110b4900a71f69c2026"><div class="highlight"><table class="highlighttable"><tr><td class="linenos"><div class="linenodiv"><pre><span class="normal">1</span>
|
|
<span class="normal">2</span></pre></div></td><td class="code"><div><pre><span></span><span class="k">DROP</span><span class="w"> </span><span class="k">EXCEPT</span><span class="w"> </span><span class="k">RULE</span><span class="w"> </span><span class="p">[</span><span class="w"> </span><span class="k">IF</span><span class="w"> </span><span class="k">EXISTS</span><span class="w"> </span><span class="p">]</span><span class="w"> </span>
|
|
<span class="w"> </span><span class="n">rule_name</span><span class="w"> </span><span class="p">;</span>
|
|
</pre></div></td></tr></table></div>
|
|
</div>
|
|
</div>
|
|
<div class="section" id="EN-US_TOPIC_0000001811634509__s3af932ca438d4159985b0e2e173ebf9d"><h4 class="sectiontitle">Parameter Description</h4><ul id="EN-US_TOPIC_0000001811634509__ul45451631164615"><li id="EN-US_TOPIC_0000001811634509__l76c9ab68ef47481cbe3d66f01a084a46"><strong id="EN-US_TOPIC_0000001811634509__ac0e9e72573634aad86d996c5f0bfd613">IF EXISTS</strong><p id="EN-US_TOPIC_0000001811634509__aadcbc68db8fe439c9eca3712be81a2cf">Sends a notice instead of an error if the specified exception rule set does not exist.</p>
|
|
</li></ul>
|
|
<ul id="EN-US_TOPIC_0000001811634509__ul63681331144619"><li id="EN-US_TOPIC_0000001811634509__lfde7b0ce8c3c4a5db0f3b2fc758835d7"><strong id="EN-US_TOPIC_0000001811634509__b17764116195810">rule_name</strong><p id="EN-US_TOPIC_0000001811634509__ad6abc158ac654e4695c2673e7abbb344">Indicates the name of the exception rule set.</p>
|
|
<p id="EN-US_TOPIC_0000001811634509__a57c751b7b8a14544aed1d4dc1b06da8d">Value range: a string of 1 to 64 characters. It must comply with the naming convention.</p>
|
|
</li></ul>
|
|
</div>
|
|
<div class="section" id="EN-US_TOPIC_0000001811634509__section370345415718"><h4 class="sectiontitle">Examples</h4><p id="EN-US_TOPIC_0000001811634509__p1344163274318">Remove the rule set named <strong id="EN-US_TOPIC_0000001811634509__b15461191111362">except_rule1</strong>:</p>
|
|
<div class="codecoloring" codetype="Sql" id="EN-US_TOPIC_0000001811634509__screen196701549164313"><div class="highlight"><table class="highlighttable"><tr><td class="linenos"><div class="linenodiv"><pre><span class="normal">1</span></pre></div></td><td class="code"><div><pre><span></span><span class="k">DROP</span><span class="w"> </span><span class="k">EXCEPT</span><span class="w"> </span><span class="k">RULE</span><span class="w"> </span><span class="n">except_rule1</span><span class="p">;</span>
|
|
</pre></div></td></tr></table></div>
|
|
</div>
|
|
<p id="EN-US_TOPIC_0000001811634509__p59211353114319">Remove the rule set named <strong id="EN-US_TOPIC_0000001811634509__b18236112720366">except_rule2</strong> if it exists:</p>
|
|
<div class="codecoloring" codetype="Sql" id="EN-US_TOPIC_0000001811634509__screen232592117441"><div class="highlight"><table class="highlighttable"><tr><td class="linenos"><div class="linenodiv"><pre><span class="normal">1</span></pre></div></td><td class="code"><div><pre><span></span><span class="k">DROP</span><span class="w"> </span><span class="k">EXCEPT</span><span class="w"> </span><span class="k">RULE</span><span class="w"> </span><span class="k">IF</span><span class="w"> </span><span class="k">EXISTS</span><span class="w"> </span><span class="n">except_rule2</span><span class="p">;</span>
|
|
</pre></div></td></tr></table></div>
|
|
</div>
|
|
</div>
|
|
<div class="section" id="EN-US_TOPIC_0000001811634509__section339233917449"><h4 class="sectiontitle">Helpful Links</h4><p id="EN-US_TOPIC_0000001811634509__p99921643144410"><a href="dws_06_0280.html">ALTER EXCEPT RULE</a>, <a href="dws_06_0281.html">CREATE EXCEPT RULE</a></p>
|
|
</div>
|
|
</div>
|
|
<div>
|
|
<div class="familylinks">
|
|
<div class="parentlink"><strong>Parent topic:</strong> <a href="dws_06_0118.html">DDL Syntax</a></div>
|
|
</div>
|
|
</div>
|
|
|