This shows you the differences between two versions of the page.
| Both sides previous revision Previous revision Next revision | Previous revision | ||
|
dev:sql:statements:disconnect:home [2010/05/11 00:31] tdo |
dev:sql:statements:disconnect:home [2016/06/28 22:38] (current) |
||
|---|---|---|---|
| Line 1: | Line 1: | ||
| {{page>:top_add&nofooter&noeditbtn}} | {{page>:top_add&nofooter&noeditbtn}} | ||
| <html><div align="center"><span style="color:red">DRAFT</span></div></html> | <html><div align="center"><span style="color:red">DRAFT</span></div></html> | ||
| + | ====== Omnidex SQL: DISCONNECT ===== | ||
| + | {{page>:sql_bar&nofooter&noeditbtn}} | ||
| - | ====== Omnidex SQL: DISCONNECT ====== | ||
| ===== Description ===== | ===== Description ===== | ||
| Line 11: | Line 12: | ||
| DISCONNECT [ALL] [[ON [INSTANCE]] instance] [WITH options] | DISCONNECT [ALL] [[ON [INSTANCE]] instance] [WITH options] | ||
| </code> | </code> | ||
| + | |||
| + | disconnect all with flush; | ||
| + | |||
| + | A DISCONNECT with the ALL modifier causes all instances to be closed. The with FLUSH option instructs the caches to flush any aged entries. This pair of options causes all entries in the caches to be released and freed. | ||