How do I drop table?

[looser]

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..

[sukimac]

drop table my_table cascade (to deal with constraints)

[Halo]

It's more like:
drop table table_name cascade constraints;

[hbk_emp]

sql> drop table emp;

or if its relational with foregin keys or primary keys then

sql> drop table emp cascade constraints;

[looser]

thanks!!

[sambavan]

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

[kmesser]

tRuncate