Debian Codegraph @

www/lang_droptable.html

raw
1 <!DOCTYPE html>
2 <html><head>
3 <meta name="viewport" content="width=device-width, initial-scale=1.0">
4 <meta http-equiv="content-type" content="text/html; charset=UTF-8">
5 <link href="sqlite.css" rel="stylesheet">
6 <title>DROP TABLE</title>
7 <!-- path= -->
8 </head>
9 <body>
10 <div class=nosearch>
11 <a href="index.html">
12 <img class="logo" src="images/sqlite370_banner.svg" alt="SQLite" border="0">
13 </a>
14 <div><!-- IE hack to prevent disappearing logo --></div>
15 <div class="tagline desktoponly">
16 Small. Fast. Reliable.<br>Choose any three.
17 </div>
18 <div class="menu mainmenu">
19 <ul>
20 <li><a href="index.html">Home</a>
21 <li class='mobileonly'><a href="javascript:void(0)" onclick='toggle_div("submenu")'>Menu</a>
22 <li class='wideonly'><a href='about.html'>About</a>
23 <li class='desktoponly'><a href="docs.html">Documentation</a>
24 <li class='desktoponly'><a href="download.html">Download</a>
25 <li class='wideonly'><a href='copyright.html'>License</a>
26 <li class='desktoponly'><a href="support.html">Support</a>
27 <li class='desktoponly'><a href="prosupport.html">Purchase</a>
28 <li class='search' id='search_menubutton'>
29 <a href="javascript:void(0)" onclick='toggle_search()'>Search</a>
30 </ul>
31 </div>
32 <div class="menu submenu" id="submenu">
33 <ul>
34 <li><a href='about.html'>About</a>
35 <li><a href='docs.html'>Documentation</a>
36 <li><a href='download.html'>Download</a>
37 <li><a href='support.html'>Support</a>
38 <li><a href='prosupport.html'>Purchase</a>
39 </ul>
40 </div>
41 <div class="searchmenu" id="searchmenu">
42 <form method="GET" action="search">
43 <select name="s" id="searchtype">
44 <option value="d">Search Documentation</option>
45 <option value="c">Search Changelog</option>
46 </select>
47 <input type="text" name="q" id="searchbox" value="">
48 <input type="submit" value="Go">
49 </form>
50 </div>
51 </div>
52 <script>
53 function toggle_div(nm) {
54 var w = document.getElementById(nm);
55 if( w.style.display=="block" ){
56 w.style.display = "none";
57 }else{
58 w.style.display = "block";
59 }
60 }
61 function toggle_search() {
62 var w = document.getElementById("searchmenu");
63 if( w.style.display=="block" ){
64 w.style.display = "none";
65 } else {
66 w.style.display = "block";
67 setTimeout(function(){
68 document.getElementById("searchbox").focus()
69 }, 30);
70 }
71 }
72 function div_off(nm){document.getElementById(nm).style.display="none";}
73 window.onbeforeunload = function(e){div_off("submenu");}
74 /* Disable the Search feature if we are not operating from CGI, since */
75 /* Search is accomplished using CGI and will not work without it. */
76 if( !location.origin || !location.origin.match || !location.origin.match(/http/) ){
77 document.getElementById("search_menubutton").style.display = "none";
78 }
79 /* Used by the Hide/Show button beside syntax diagrams, to toggle the */
80 function hideorshow(btn,obj){
81 var x = document.getElementById(obj);
82 var b = document.getElementById(btn);
83 if( x.style.display!='none' ){
84 x.style.display = 'none';
85 b.innerHTML='show';
86 }else{
87 x.style.display = '';
88 b.innerHTML='hide';
89 }
90 return false;
91 }
92 var antiRobot = 0;
93 function antiRobotGo(){
94 if( antiRobot!=3 ) return;
95 antiRobot = 7;
96 var j = document.getElementById("mtimelink");
97 if(j && j.hasAttribute("data-href")) j.href=j.getAttribute("data-href");
98 }
99 function antiRobotDefense(){
100 document.body.onmousedown=function(){
101 antiRobot |= 2;
102 antiRobotGo();
103 document.body.onmousedown=null;
104 }
105 document.body.onmousemove=function(){
106 antiRobot |= 2;
107 antiRobotGo();
108 document.body.onmousemove=null;
109 }
110 setTimeout(function(){
111 antiRobot |= 1;
112 antiRobotGo();
113 }, 100)
114 antiRobotGo();
115 }
116 antiRobotDefense();
117 </script>
118 <div class=fancy>
119 <div class=nosearch>
120 <div class="fancy_title">
121 DROP TABLE
122 </div>
123 </div>
124
125
126
127
128 <p><b><a href="syntax/drop-table-stmt.html">drop-table-stmt:</a></b>
129 <button id='xa474c09d' onclick='hideorshow("xa474c09d","xbbb7e16d")'>hide</button></p>
130 <div id='xbbb7e16d' class='imgcontainer'>
131 <div style="max-width:758px"><svg xmlns='http://www.w3.org/2000/svg' style='font-size:initial;' class="pikchr" viewBox="0 0 758.16 54" data-pikchr-date="20250319161943">
132 <circle cx="5.76" cy="17.28" r="3.6" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
133 <polygon points="32.4,17.28 20.88,21.6 20.88,12.96" style="fill:rgb(0,0,0)"/>
134 <path d="M9.36,17.28L26.64,17.28" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
135 <path d="M47.52,32.4L78.5664,32.4A15.12 15.12 0 0 0 93.6864 17.28A15.12 15.12 0 0 0 78.5664 2.16L47.52,2.16A15.12 15.12 0 0 0 32.4 17.28A15.12 15.12 0 0 0 47.52 32.4Z" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
136 <text x="63.0432" y="17.28" text-anchor="middle" fill="rgb(0,0,0)" dominant-baseline="central">DROP</text>
137 <polygon points="116.726,17.28 105.206,21.6 105.206,12.96" style="fill:rgb(0,0,0)"/>
138 <path d="M93.6864,17.28L110.966,17.28" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
139 <path d="M131.846,32.4L171.187,32.4A15.12 15.12 0 0 0 186.307 17.28A15.12 15.12 0 0 0 171.187 2.16L131.846,2.16A15.12 15.12 0 0 0 116.726 17.28A15.12 15.12 0 0 0 131.846 32.4Z" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
140 <text x="151.517" y="17.28" text-anchor="middle" fill="rgb(0,0,0)" dominant-baseline="central">TABLE</text>
141 <polygon points="222.307,17.28 210.787,21.6 210.787,12.96" style="fill:rgb(0,0,0)"/>
142 <path d="M186.307,17.28L216.547,17.28" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
143 <path d="M237.427,32.4A15.12 15.12 0 0 0 252.547 17.28A15.12 15.12 0 0 0 237.427 2.16A15.12 15.12 0 0 0 222.307 17.28A15.12 15.12 0 0 0 237.427 32.4Z" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
144 <text x="237.427" y="17.28" text-anchor="middle" fill="rgb(0,0,0)" dominant-baseline="central">IF</text>
145 <polygon points="275.587,17.28 264.067,21.6 264.067,12.96" style="fill:rgb(0,0,0)"/>
146 <path d="M252.547,17.28L269.827,17.28" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
147 <path d="M290.707,32.4L335.347,32.4A15.12 15.12 0 0 0 350.467 17.28A15.12 15.12 0 0 0 335.347 2.16L290.707,2.16A15.12 15.12 0 0 0 275.587 17.28A15.12 15.12 0 0 0 290.707 32.4Z" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
148 <text x="313.027" y="17.28" text-anchor="middle" fill="rgb(0,0,0)" dominant-baseline="central">EXISTS</text>
149 <polygon points="404.467,17.28 392.947,21.6 392.947,12.96" style="fill:rgb(0,0,0)"/>
150 <path d="M350.467,17.28L398.707,17.28" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
151 <path d="M419.587,32.4L515.952,32.4A15.12 15.12 0 0 0 531.072 17.28A15.12 15.12 0 0 0 515.952 2.16L419.587,2.16A15.12 15.12 0 0 0 404.467 17.28A15.12 15.12 0 0 0 419.587 32.4Z" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
152 <text x="467.77" y="17.28" text-anchor="middle" fill="rgb(0,0,0)" dominant-baseline="central">schema-name</text>
153 <polygon points="554.112,17.28 542.592,21.6 542.592,12.96" style="fill:rgb(0,0,0)"/>
154 <path d="M531.072,17.28L548.352,17.28" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
155 <path d="M569.232,32.4A15.12 15.12 0 0 0 584.352 17.28A15.12 15.12 0 0 0 569.232 2.16A15.12 15.12 0 0 0 554.112 17.28A15.12 15.12 0 0 0 569.232 32.4Z" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
156 <text x="569.232" y="17.28" text-anchor="middle" font-weight="bold" fill="rgb(0,0,0)" dominant-baseline="central">.</text>
157 <polygon points="620.352,17.28 608.832,21.6 608.832,12.96" style="fill:rgb(0,0,0)"/>
158 <path d="M584.352,17.28L614.592,17.28" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
159 <path d="M635.472,32.4L710.64,32.4A15.12 15.12 0 0 0 725.76 17.28A15.12 15.12 0 0 0 710.64 2.16L635.472,2.16A15.12 15.12 0 0 0 620.352 17.28A15.12 15.12 0 0 0 635.472 32.4Z" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
160 <text x="673.056" y="17.28" text-anchor="middle" fill="rgb(0,0,0)" dominant-baseline="central">table-name</text>
161 <polygon points="748.8,17.28 737.28,21.6 737.28,12.96" style="fill:rgb(0,0,0)"/>
162 <path d="M725.76,17.28L743.04,17.28" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
163 <circle cx="752.4" cy="17.28" r="3.6" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
164 <polygon points="275.587,47.52 264.067,51.84 264.067,43.2" style="fill:rgb(0,0,0)"/>
165 <path d="M186.307,17.28 L 193.807,17.28 Q 201.307,17.28 201.307,32.28 L 201.307,32.52 Q 201.307,47.52 216.307,47.52 L 254.827,47.52 L 269.827,47.52" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
166 <path d="M275.587,47.52 L 350.467,47.52 Q 365.467,47.52 365.467,32.52 L 365.467,32.28 Q 365.467,17.28 372.967,17.28 L 380.467,17.28" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
167 <polygon points="467.77,47.52 456.25,51.84 456.25,43.2" style="fill:rgb(0,0,0)"/>
168 <path d="M372.187,17.28 L 379.687,17.28 Q 387.187,17.28 387.187,32.28 L 387.187,32.52 Q 387.187,47.52 402.187,47.52 L 447.01,47.52 L 462.01,47.52" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
169 <path d="M467.77,47.52 L 584.352,47.52 Q 599.352,47.52 599.352,32.52 L 599.352,32.28 Q 599.352,17.28 606.852,17.28 L 614.352,17.28" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
170 </svg>
171 </div>
172 </div>
173
174
175 <p>The DROP TABLE statement removes a table added with the
176 <a href="lang_createtable.html">CREATE TABLE</a> statement. The name specified is the
177 table name. The dropped table is completely removed from the database
178 schema and the disk file. The table can not be recovered.
179 All indices and triggers
180 associated with the table are also deleted.</p>
181
182 <p>The optional IF EXISTS clause suppresses the error that would normally
183 result if the table does not exist.</p>
184
185 <p>If <a href="foreignkeys.html">foreign key constraints</a> are enabled, a DROP TABLE command performs an
186 implicit <a href="lang_delete.html">DELETE FROM</a> command before removing the
187 table from the database schema. Any triggers attached to the table are
188 dropped from the database schema before the implicit DELETE FROM
189 is executed, so this cannot cause any triggers to fire. By contrast, an
190 implicit DELETE FROM does cause any configured
191 <a href="foreignkeys.html#fk_actions">foreign key actions</a> to take place.
192 If the implicit DELETE FROM executed
193 as part of a DROP TABLE command violates any immediate foreign key constraints,
194 an error is returned and the table is not dropped. If
195 the implicit DELETE FROM causes any
196 deferred foreign key constraints to be violated, and the violations still
197 exist when the transaction is committed, an error is returned at the time
198 of commit.
199 </p><p align="center"><small><i>This page was last updated on 2022-01-08 05:02:57Z </small></i></p>
200