|Deletes all foreign keys that reference the table.|
|Bypasses the recycle bin and completely drops the table. Purged tables cannot be recovered.|
In Oracle version 10g and later, a recycle bin is available to retrieve tables and associated objects (such as indexes, constraints, and triggers) you have dropped from the database. From the Schema Browser's Recycle Bin page you can access this bin and retrieve dropped tables if necessary.
To flashback a table
When you view a table's data in the Schema Browser, you can split the window to also show child or parent tables in a new detail grid. You can also change the query for the detail grid.
To view parent/child datasets in the Schema Browser
Select the Data tab and click on the Data tab toolbar.
If the table has a single foreign key, Toad automatically displays the related table. If there is more than one foreign key, click the arrow beside on the detail grid toolbar and select a table. Toad remembers your selection.
You can assign object privileges from the Create or Alter User windows, or from the Privileges window.
To access the Add Object Privileges window
Select an Object Type and choose objects to grant privileges on, using the arrow buttons to move those objects to the Grants grid on the right.
The Privileges window allows you to view, grant, and revoke privileges on a database object. You can view all users and their privileges. If you are not the object owner, you can only grant privileges if you have been given the "grant option."
To access the Privileges window
Click on the left-hand side toolbar. Grants are highlighted in blue and admin grants in yellow.
Tip: If you do not see all users, make sure Hide privileges granted by other users or Hide users/roles with no privileges assigned is not selected.