Truncating a Precomputed Result Set

Truncating a precomputed result set removes the data but retains the definition of the precomputed result set in the system table.

  1. In the Administration Console view, select ASE Servers > Compiled Objects > Precomputed Result Sets.
  2. Highlight the precomputed result set to change, and select Truncate.
  3. From the Confirm Truncate window, select:
    • Preview – to view the SQL text of the precomputed result set you are truncating
    • Yes – to truncate the data in the precomputed result set.
    • No – to cancel the truncate.
Parent topic: Precomputed Result Sets