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