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

Howdy, Stranger!

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

Categories

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

Damian99Damian99 USAPosts: 116Member

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

Tagged:

Comments

  • unblockableunblockable NigeriaPosts: 3Member

    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.