Rules for temporary and volatile tables are as follows:
IF a table is this type … | THEN the following things occur when you delete a database … |
---|---|
global temporary |
|
volatile | All objects in the target database are dropped except volatile tables. |
Rules for temporary and volatile tables are as follows:
IF a table is this type … | THEN the following things occur when you delete a database … |
---|---|
global temporary |
|
volatile | All objects in the target database are dropped except volatile tables. |