How to truncate the table with cascade option?

I tried "truncate table cascade
but I got the error storage keyword is missing (says either drop storage or reuse storage)
Can any one help me out.

Interview Candidate
Sep 16th, 2007
6
18430

SQL

Answer

First
Prev
Next
Last

Showing Answers 1 - 6 of 6 Answers

vemurisasidhar
Profile Answers by vemurisasidhar

Sep 22nd, 2007

if u want to delete a table with constraints i think u need to first disable the constraints on the table and the use
truncate table <table_name>;

alter table <table_name>
disable constraint <constraint_name> primary key cascade;