List tables which has fulltext index

Share It!

If you have to get list of tables for specific database which table has FULLTEXT index use following command:

# SELECT TABLE_NAME FROM information_Schema.STATISTICS WHERE table_schema = 'DATABASE_NAME' AND index_type = 'FULLTEXT' ORDER BY index_name;
Example: SELECT TABLE_NAME FROM information_Schema.STATISTICS WHERE table_schema = 'mydatabase AND index_type = 'FULLTEXT' ORDER BY index_name;

Leave a Reply

Your email address will not be published.