Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Check database schemas mysql

Tags:

mysql

Is there a command in the MySQL command line client for windows that allows you to view all tables in a database, or display the schema of a particular table, similar to .tables in sqlite3 or \dt in psql?

like image 366
ewok Avatar asked Oct 28 '25 01:10

ewok


1 Answers

[misread]

You're looking for SHOW TABLES it sounds like.

To see the schema of a table, use DESCRIBE table_name;

like image 127
BRPocock Avatar answered Oct 30 '25 17:10

BRPocock



Donate For Us

If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!