SHOW command in SQL
The SHOW command in SQL is primarily used in MySQL, MariaDB, and some other SQL-based databases to retrieve metadata about the database and its objects. It is not part of the SQL standard but is specific to certain SQL implementations. Here are some commonly used SHOW commands:
MySQL and MariaDB 1. Show all databases:
SQL Syntax
SHOW DATABASES;
2. Show all tables in the current database:
SQL Syntax
SHOW TABLES;
3. Show columns of a specific table:
SQL Syntax
SHOW COLUMNS FROM table_name;
Or:
DESCRIBE table_name;
Or:
DESCRIBE table_name;