| Deleting Tables [message #371776] |
Mon, 04 December 2000 15:36  |
Matthieu Cornillon
Messages: 3
Registered: December 2000
|
Junior Member |
|
|
Hi. I am a complete newbie. I have just created my first table. I now want to know how to delete it. I'm hoping that this is an easy one.
Thanks!
|
|
|
|
| Re: Deleting Tables [message #371777 is a reply to message #371776] |
Mon, 04 December 2000 16:15  |
Chandra Poludasu
Messages: 1
Registered: December 2000
|
Junior Member |
|
|
You can delete a table by issuing
drop table table_name; This command deletes the table permanantly. You can never see the data as well as the structure of the table.
If you want to permanantly delete the data keeping the structure as it is, you can say
truncate table table_name;
If you want to delete all the data temporarily, you can say
delete from table_name;. You can issue a where clause to delete a particular set of records.
|
|
|
|
| Re: Deleting Tables [message #373020 is a reply to message #371777] |
Thu, 22 March 2001 21:44 |
Vince
Messages: 11
Registered: December 2000
|
Junior Member |
|
|
Hey there!
I can usually delete tables with the DROP TABLE
; command. Now, when I type that in, I get: ERROR at line 1:
ORA-00054: resource busy and acquire with NOWAIT specified
Can someone help me? THANKS!!
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
