SQL to show all tables in database - character set / collation settings

What SQL should I run to show all tables in database with related settings like table engine, character set / collation ? How can I get these information ?
27 May 2021 at 08:42 AM
0give a positive ratinggive a negative ratingshow more
StorStor
Hi,

To get the list of all tables in database by using SQL, you can use:

SHOW TABLE STATUS;
In the results, you can find information about table engine, character set etc.
29 May 2021 at 11:53 AM
0give a positive ratinggive a negative ratingshow more
TimTim
Is it possible to somehow get the results using SELECT, so I can use the results also for other purposes ?
30 May 2021 at 04:48 PM
0give a positive ratinggive a negative ratingshow more
StorStor
Share on FacebookShare on TwitterShare on LinkedInSend email
Follow us on Facebook
2022 AnswerTabsTermsContact us