show table status command in mysql
snippet in sql

show table status command in mysql

user1393

SHOW TABLE STATUS FROM DB_name WHERE name = 'table_name';