Skip to content

Instantly share code, notes, and snippets.

@richjenks

richjenks/find-table.sql

Created April 16, 2016 07:52
Show Gist options
  • Save richjenks/9883ccfc2e0b1c1ffccd52e273bc77de to your computer and use it in GitHub Desktop.
Save richjenks/9883ccfc2e0b1c1ffccd52e273bc77de to your computer and use it in GitHub Desktop.
Download ZIP
Raw
find-table.sql
USE database
SELECT * FROM INFORMATION_SCHEMA.TABLES
WHERE TABLE_NAME LIKE '%attachment%'
AND TABLE_TYPE = 'BASE TABLE'
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment