Create Tables

Learn how to create tables in a database.

We'll cover the following

Showing tables

As we learned in our introduction to RDBMS, a database can have many tables. How can we get the list of tables of the current database, though? This is done with the help of the show tables; command. When we issue the command on the customers_db database, we get the output Empty set, which means the action was completed successfully with no results to show. That’s why we should get Succeeded in the result box of the following query:

Get hands-on with 1200+ tech skills courses.