show table status command in mysql 1

show table status command in mysql

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

Here is what the above code is Doing:
1. We’re using the SHOW TABLE STATUS command to get information about the table.
2. We’re using the WHERE clause to filter the results to only show us the table we’re interested in.
3. We’re using the FROM clause to specify the database we want to get the information from.

Similar Posts