delete tables in sql 1

[props]

how can i delete a table in sql? becasue i have create a table called publisher and i can't erase it. Is this has something to do with the clear buffer ??

Thanks in advance

 

[BJCooperIT]

Try in SQL*Plus:

drop table publisher;

^{Beware of false knowledge; it is more dangerous than ignorance. ~George Bernard Shaw}
Consultant/Custom Forms & PL/SQL - Oracle 8.1.7 - Windows 2000

 

[karluk]

Please explain what you mean by "erase". That's not an Oracle term, so it's unclear whether you want to drop the table as BJ Cooper suggests, or simply delete all the rows but keept the table structure.

 

[bobby13]

There are two ways you can get rid of a table first is asBJ Cooper suggested simple

SQL> drop table publisher;

NOTE: This will remove the entire table structure, its content, and constraints. Basically the table will be completely deleted from the database!

The second method is:

SQL>delete from publisher;
NOTE: This will delete all the rows in the table not the table structure so you can populate the table again.

or you can use truncate, but i won't go into that, hope this helps!


Regards
Bobby

 

[sem]

Bobby, the third one is somewhere between:

truncate table publisher

Regards, Dima