Skip to content

Instantly share code, notes, and snippets.

@alexanderjsingleton

alexanderjsingleton/oracleSQL_robocop.sql

Created May 5, 2016 23:45
Show Gist options
  • Save alexanderjsingleton/a5ac2342479807e6fc7a9691d15cb6e1 to your computer and use it in GitHub Desktop.
Save alexanderjsingleton/a5ac2342479807e6fc7a9691d15cb6e1 to your computer and use it in GitHub Desktop.
Download ZIP
"DROP 'EM, CREEP!" -RoboCob | A SQL-snipper to clear/purge all table-data.
Raw
oracleSQL_robocop.sql
SELECT 'drop table '||table_name||' cascade constraints;' FROM user_tables;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment