http://sqle.ru/index.php?action=history&feed=atom&title=Oracle_PL%2FSQL%2FTable%2FDrop_Table
Oracle PL/SQL/Table/Drop Table - История изменений
2026-05-26T03:17:28Z
История изменений этой страницы в вики
MediaWiki 1.30.0
http://sqle.ru/index.php?title=Oracle_PL/SQL/Table/Drop_Table&diff=1036&oldid=prev
в 13:45, 26 мая 2010
2010-05-26T13:45:19Z
<p></p>
<table class="diff diff-contentalign-left" data-mw="interface">
<tr style="vertical-align: top;" lang="ru">
<td colspan="1" style="background-color: white; color:black; text-align: center;">← Предыдущая</td>
<td colspan="1" style="background-color: white; color:black; text-align: center;">Версия 13:45, 26 мая 2010</td>
</tr><tr><td colspan="2" style="text-align: center;" lang="ru"><div class="mw-diff-empty">(нет различий)</div>
</td></tr></table>
http://sqle.ru/index.php?title=Oracle_PL/SQL/Table/Drop_Table&diff=1037&oldid=prev
Admin: 1 версия
2010-05-26T09:54:51Z
<p>1 версия</p>
<p><b>Новая страница</b></p><div>==Delete a table if it exists==<br />
<br />
<br />
<br />
<br />
<!-- start source code --><br />
<br />
<source lang="sql"><br />
<br />
SQL> BEGIN<br />
2 FOR i IN (SELECT null FROM user_tables WHERE table_name = "INDIVIDUALS") LOOP<br />
3 EXECUTE IMMEDIATE "DROP TABLE individuals CASCADE CONSTRAINTS";<br />
4 END LOOP;<br />
5 END;<br />
6 /<br />
PL/SQL procedure successfully completed.<br />
<br />
<br />
<br />
</source><br />
<br />
<br />
<br />
<br />
==Drop a table demo==<br />
<br />
<br />
<br />
<br />
<!-- start source code --><br />
<br />
<source lang="sql"><br />
<br />
SQL><br />
SQL> create table drop_me(<br />
2 a int,<br />
3 b int<br />
4 );<br />
Table created.<br />
SQL><br />
SQL> insert into drop_me values ( 1, 1 );<br />
1 row created.<br />
SQL><br />
SQL> insert into drop_me values ( 1, 2 );<br />
1 row created.<br />
SQL><br />
SQL> insert into drop_me values ( 2, 1 );<br />
1 row created.<br />
SQL><br />
SQL> drop table drop_me;<br />
Table dropped.<br />
SQL><br />
SQL><br />
<br />
<br />
<br />
</source><br />
<br />
<br />
<br />
<br />
==Drop only if table exists.==<br />
<br />
<br />
<br />
<br />
<!-- start source code --><br />
<br />
<source lang="sql"><br />
<br />
SQL> BEGIN<br />
2<br />
3 FOR i IN (SELECT table_name FROM user_tables WHERE table_name = "SHARED_ALL") LOOP<br />
4 EXECUTE IMMEDIATE "DROP TABLE shared_all";<br />
5 END LOOP;<br />
6<br />
7 END;<br />
8 /<br />
PL/SQL procedure successfully completed.<br />
SQL><br />
<br />
<br />
<br />
</source><br />
<br />
<br />
<br />
<br />
==Drop table with CASCADE CONSTRAINTS==<br />
<br />
<br />
<br />
<br />
<!-- start source code --><br />
<br />
<source lang="sql"><br />
<br />
SQL><br />
SQL> create table gender_tab (<br />
2 gender_id char(1),<br />
3 gender_nm varchar2(6),<br />
4 constraint gender_pk primary key (gender_id),<br />
5 constraint gender_id_ck check (gender_id in ("M", "F"))<br />
6 );<br />
Table created.<br />
SQL><br />
SQL> insert into gender_tab values ("F", "Female");<br />
1 row created.<br />
SQL> insert into gender_tab values ("M", "Male");<br />
1 row created.<br />
SQL><br />
SQL> create table people (<br />
2 first_name varchar2(20),<br />
3 last_name varchar2(25),<br />
4 gender char(1)<br />
5 );<br />
Table created.<br />
SQL><br />
SQL> alter table people<br />
2 add constraint people_gender_fk<br />
3 foreign key (gender)<br />
4 references gender_tab;<br />
Table altered.<br />
SQL><br />
SQL> insert into people values ("S", "Dillon", "M");<br />
1 row created.<br />
SQL> insert into people values ("C", "Beck", "M");<br />
1 row created.<br />
SQL> insert into people values ("N", "Ellis", "F");<br />
1 row created.<br />
SQL><br />
SQL> drop table gender_tab;<br />
drop table gender_tab<br />
*<br />
ERROR at line 1:<br />
ORA-02449: unique/primary keys in table referenced by foreign keys<br />
<br />
SQL><br />
SQL> drop table gender_tab cascade constraints;<br />
Table dropped.<br />
SQL><br />
SQL><br />
<br />
<br />
</source></div>
Admin