-
I got 3 Oracle books, and I still can't find how to drop the damn table.
maybe this isn't for me. but then again, I hate flippin burgers..
help please..
-
drop table my_table cascade (to deal with constraints)
-
It's more like:
drop table table_name cascade constraints;
-
table drop
sql> drop table emp;
or if its relational with foregin keys or primary keys then
sql> drop table emp cascade constraints;
Best Regards,
Harsh Shah
-
-
On the other hand if you ever want only the data to be droped and would want to preserve the schema, then you do a tuncate on the table.
Sam
Thanx
Sam
Life is a journey, not a destination!
-
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|