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

Navin,

You can drop any column .. please give me little more details so I can help...

Thanks,
Beena

hi navin..

Iam not sure bt..guess u could delete the row using delete command and commit it.....

thanks,

cm

Simply delete the records and commit .

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

u can delete the column by using

delete from [tabname] where [column]