O'Reilly logo

MySQL 8 Cookbook by Karthik Appigatla

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Using SHOW TABLE STATUS

You can execute the SHOW TABLE STATUS command and check Create_options in the output:

mysql> SHOW TABLE STATUS LIKE 'employees'\G*************************** 1. row ***************************           Name: employees         Engine: InnoDB        Version: 10     Row_format: Dynamic           Rows: NULL Avg_row_length: NULL    Data_length: NULLMax_data_length: NULL   Index_length: NULL      Data_free: NULL Auto_increment: NULL    Create_time: 2017-10-01 05:01:53    Update_time: NULL     Check_time: NULL      Collation: utf8mb4_0900_ai_ci       Checksum: NULL Create_options: partitioned        Comment: 1 row in set (0.00 sec)

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required