This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
We need to be able to do Truncate and Append as opposed to Delete and Append because Deleting the contents in the table takes too long.
Tried doing this In-Db but that didn't work.
In this thread: Truncate Table Error Writing to SQL Database after 11.3 Upgrade the advice said to use the Pre Create SQL Statement and I was successful using Truncate: TRUNCATE TABLE owner.table_name
However, I want to be able to do this while In-Database. Is there any way to do that?