how to drop records from zcustomized tables directly. urgent

[Former Member]

Hi all,

created zindia table unfortunately data is uploaded i wrong format & can't manage to delete through sap R/3 if i want to drop records directly through sqlplus> how can i do that

I mean wanted to access the database

Pls advice me with full steps

Rahul

[Former Member]

hi

thanx a lot but i used se16n selected the record & deleted .thanx a lot

[Former Member]

Hi Rahul,

you can use truncate command in SQL prompt, if you dont want that table structure use drop command at sql prompt drop table <tablename>;

Regds,

Chandra

[markus_doehr2]

Either use SE14 and "activate and adjust table" with "Delete data" or use sqlplus and "truncate table <tablename>".

Markus