DROP DATABASE

    • DATABASE SCHEMA

      DATABASE and SCHEMA mean the same thing, either of them can be used.

    • RESTRICT

    • CASCADE

      If specified, will drop all the associated tables and functions.

    2. CREATE DATABASE inventory_db COMMENT 'This database is used to maintain Inventory';
    7. DROP DATABASE IF EXISTS inventory_db CASCADE;