how to delete all the rows from a table? [message #39464] |
Thu, 18 July 2002 07:00 |
figen
Messages: 10 Registered: July 2002
|
Junior Member |
|
|
Truncate or Delete? I know Delete might cause a lot of rollback and fire all the delete triggers. But I cannot use "Truncate" command from a procedure, because it is DDL command.
I am writng a Java script which will call Procedure and take the "table_name" as an argument and delete all the rows in that table.
Is there any way doing this from a Java Script other than Procedure or how should be the procedure?
Thanks in advance
|
|
|
|
Re: how to delete all the rows from a table? [message #39467 is a reply to message #39464] |
Thu, 18 July 2002 07:55 |
figen
Messages: 10 Registered: July 2002
|
Junior Member |
|
|
Thank you so much Mahesh, but I have no idea what the dynamic SQL is, Can you give me a link or any resource that I can learn in a "very" short period of time?
And do you think is "truncate" better way to go?
Thanks again
|
|
|
|
|