How to check the engine type for a table in MySQL?

I need to check the engine type for a table in MySQL. What is the command should be used?

Comments

  • SELECT TABLE_NAME, ENGINE FROM information_schema.TABLES where TABLE_SCHEMA = 'dbname'



    Replace "dbname" with your

    database name. Run it.

Sign In or Register to comment.

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

Categories

In this Discussion