truncate in scripts
I found a SQR routine that runs a delete from on a table to clear its contents every run. Obviously I want to get this replaced with a truncate instead but the programmers complain that if they create their own test tables and run this routine it won't work because the schema name is hard coded for the production schema.
I'm thinking of ways around it (if forced to) but I wanted to post this to see what ideas or experience you may be able to share.
Thank you