Delete Contents of Table Permanently
Hi All
can anyone please tell me how to delete permanently required contents of the table?
ex: I have a table called ABCD it has several columns. one column is sale date.
I would like to delete some of the sales entries made on such date permanently.
plz any one help me its very urjent.
NASH
Re: Delete Contents of Table Permanently
Navin,
You can drop any column .. please give me little more details so I can help...
Thanks,
Beena
Re: Delete Contents of Table Permanently
hi navin..
Iam not sure bt..guess u could delete the row using delete command and commit it.....
thanks,
cm
Re: Delete Contents of Table Permanently
Simply delete the records and commit .
Re: Delete Contents of Table Permanently
[QUOTE=Beena;28990]Navin,
You can drop any column .. please give me little more details so I can help...
Thanks,
Beena[/QUOTE]
Drop is a DDL , it changes the table structure not only the data .
Re: Delete Contents of Table Permanently
u can delete the column by using
delete from [tabname] where [column]