Database Systems with SQL - Full Course - 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!