One Star

Empty Tables

Hi all,
i am trying to create a job, that delete all rows in my tables and make them empty.
Any suggestion how?
Thanks
2 REPLIES
One Star

Re: Empty Tables

Here are two simple methods:
Use a tOracleRow component. In the query, type "Delete from tablename where 1 = 1". Do this for each table you want to clear.
Use a tOracleOutput component. In the dropdown for "Action on table", select "Clear Table". This will delete all data in the table before inserting the new data.
Although I am referring to tOracle components, the same function is available for other databases. Just use the right component for the database you are working with.
One Star

Re: Empty Tables

I used tOracleRow and it works.
Thanks !