Studied by 0 people
Looks like no one added any tags here yet for you.
What command is used to create a new database in a database management system?
CREATE DATABASE Database_name
What command removes a database from the system?
DROP DATABASE Database_name
What does the USE Database_name command do?
Selects a default database for use in subsequent statements.
What does the SHOW DATABASES command do?
Lists all databases in the database system instance.
What command would you use to see all tables in the default database?
SHOW TABLES
What is the purpose of the SHOW COLUMNS FROM Table_Name command?
Lists all columns in the specified table of the default database.
What does the SHOW CREATE TABLE Table_Name command display?
Shows the CREATE TABLE statement for the specified table in the default database.
