A view is exactly that, a constructed view of the underlying tables, essentially a saved or materialized SQL (SELECT) query.

If you want to truncate the view, then really you should truncate the underlying tables, not the view itself (obviously you can delete rows from a view which may filter to the underlying table provided it meets certain conditions) - I don't think that even if the conditions are met, that can apply the TRUNCATE command to the view and affect the underlying table.

As indicated in previous answer - you can drop the view - again, by doing so, you will not have any impact on the underlying tables/data.

Saying that, the error message displayed is a little poor, which doesn't help,

HTH,

B