Skip to content

Instantly share code, notes, and snippets.

@zarkosusnjar

zarkosusnjar/gist:731941

Created December 7, 2010 15:52
Show Gist options
  • Save zarkosusnjar/731941 to your computer and use it in GitHub Desktop.
Save zarkosusnjar/731941 to your computer and use it in GitHub Desktop.
Download ZIP
Creating drop script for multiple tables with same name prefix
Raw
gistfile1.sql
-- Example found on http://goo.gl/nfiBq
SELECT 'drop table [' + TABLE_SCHEMA + '].[' + TABLE_NAME + ']'
FROM INFORMATION_SCHEMA.TABLES
WHERE TABLE_NAME like 'cms%'
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment