The PS4 can upload screenshots from both within and outside of games. To capture and upload a screenshot, press the Share button on the DualShock 4. This takes a snapshot and opens a menu.
DROP TABLE goes further than a TRUNCATE in that it actually removes the table from the database completely. This includes removing all associated objects, such as indexes and constraints. If you dropped a table, not only would you remove all the data, but the structure as well.
Here is another option. Create a trunc function in sql server. For some reason, I have to use dbo. to run it. If anyone knows how to eliminate that part it would be helpful. Anyway, here is the function with a day, month, or year. If you need more, just add them in. CREATE FUNCTION trunc