SHOW

Definition:

An SQL statement that output something in the database.

(Remark:Although this keyword does not exist in HKDSE ICT candidates’ reference sheet,it is better to remember this keyword.)

---

Command Syntax:

SHOW DATABASE; 

• show the list of databases name

SHOW TABLES; 

• show the list of tables in the database used
• (required)before USE database_name; - SQL statement

SHOW CREATE TABLE table_name; 

• show the constraints,indexes of the table
• reference:link

---

'The easiest part of stuyding SQL.'By secondary 5 student