Truncate Data in a Table

You can remove all data in a table by truncating the table. Truncating a table removes the data, but retains the schema. You might want to truncate a table if the table contains some bad data.

If you've previously published a derived dataset based on this table, the associated Prism data source still contains data. If you also want to remove the data from the associated Prism data source, then you must publish the derived dataset again. Publishing a derived dataset from a truncated table makes the associated Prism data source empty, but active.

If you selected the

Enable for Analysis

option for this table, then truncating the table also removes all data from the associated Prism data source. The Prism data source is empty, but active.