Database Systems - How to create a Database - CREATE DATABASE Statement
You can create a new database with the CREATE DATABASE statement. After creating a database, that is when you can start adding tables to it. To delete a database, use the DROP DATABASE statement, which also deletes all tables in that database.
Examples:
CREATE DATABASE movies;
CREATE DATABASE albums;
DROP DATABASE movies;
The SHOW statement shows the database developer some useful information about your database tables and columns.
Examples:
SHOW DATABASES – lists all available databases. You can choose which database to use with the USE statement. Ex: Use albums;
SHOW TABLES – lists all tables in the database you are currently using
SHOW COLUMNS FROM tableName – lists all the columns of a table, where tableName is the name of the table
SHOW CREATE TABLE – shows the CREATE TABLE statement used to create the table
The USE statement selects a database
Subscribe to Appficial for more programming videos coming soon. Also, don't forget to click LIKE and comment on the video if it helped you out!