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. Click the Name field of the precomputed result set, then click the drop-down arrow 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.