Skip to content

Instantly share code, notes, and snippets.

@codeprimate

codeprimate/fulltext_keys.sql

Created September 19, 2012 18:34
Show Gist options
  • Save codeprimate/3751348 to your computer and use it in GitHub Desktop.
Save codeprimate/3751348 to your computer and use it in GitHub Desktop.
Download ZIP
List all FULLTEXT keys used in the Current MySQL Database
Raw
fulltext_keys.sql
SELECT DISTINCT TABLE_NAME AS `table`, COLUMN_NAME AS `key`, index_type AS `index_type` FROM information_schema.statistics WHERE table_schema=DATABASE() AND index_type='FULLTEXT';
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment