delete data in SQL Server using TOAD loaded by Datastage?

[aschand]

Hi

I have loaded data into tables through SQL Server as a Stage in Datastage.

Now i need to delete the data and reload with new data.

I actually use toad to view data and stuff...

So can I just write in the toad the delete statement for that particular table and execute.... the table also consists of other data along with the i need to delete. Will it effect the other data too or should that work ?

thanks for the help
aschand

[kcbland]

You will delete whatever rows fall under the WHERE in your delete statement. There's no knowledge in a database of how, when, or why data is loaded into a table unless those attributes are in the table and thus you could qualify your delete's WHERE clause accordingly.

[aschand]

thank you