Sql server show tables

Summary: in this tutorial, you will learn how to list all the available databases in the MySQL server using the command line and MySQL Command Line tool.

As a database developer or administrator, the first thing you want to do after logging into the MySQL server is to list all the databases in the MySQL server.

Also, you may want to list all available tables in a particular database or schema and user accounts and their privileges.

SHOW DATABASES in MySQL

The easiest way to list all the databases available in MySQL is by logging into the MySQL server using client and issuing command.

SHOW DATABASES;

To list all databases in the MySQL database server, first log in to the database server as follows:

mysql -u root -p

It will ask you for the  password.

Enter password:

You give the correct  password of the MySQL server and press enter.

If everything goes well then you will see  on the screen. Now, use the command:

mysql> show databases; +--------------------+ | Database | +--------------------+ | companydb | | information_schema | | mysql | | performance_schema | | sys | | worl

sql script to list all databases

sql query to list all databases and sizes