This shows you the differences between two versions of the page.
|
dev:sql:statements:drop_table:home [2010/07/04 04:07] tdo |
dev:sql:statements:drop_table:home [2016/06/28 22:38] |
||
|---|---|---|---|
| Line 1: | Line 1: | ||
| - | {{page>:top_add&nofooter&noeditbtn}} | ||
| - | <html><div align="center"><span style="color:red">DRAFT</span></div></html> | ||
| - | ====== Omnidex SQL: DROP DATABASE ====== | ||
| - | |||
| - | ===== Description ===== | ||
| - | |||
| - | Drops (Removes) a table from the Omnidex Environment. Note that for RDBMS permanent tables, the table is removed from the Omnidex metadata layer but does not remove an underlying RDBMS table if the Omnidex environment is connected to an RDBMS data base. | ||
| - | |||
| - | For Temporary RDBMS tables, the DROP TEMPORARY TABLE command will remove the temporary table from the underlying RDBMS. | ||
| - | |||
| - | ===== Syntax ===== | ||
| - | |||
| - | <code> | ||
| - | DROP [TEMPORARY] TABLE | ||
| - | [IF EXISTS] table | ||
| - | [<IN "filename" | ON [INSTANCE] instance>] | ||
| - | [WITH options] | ||
| - | </code> | ||
| - | | ||
| - | |||
| - | ===== Discussion ===== | ||
| - | |||
| - | == arg1 == | ||
| - | |||
| - | == arg2 == | ||
| - | |||
| - | ===== Examples ===== | ||
| - | |||
| - | ==== Simple ==== | ||
| - | |||
| - | ==== 2nd example ==== | ||
| - | |||
| - | {{page>:bottom_add&nofooter&noeditbtn}} | ||