Knowledge Hub — Technical Document

Generated on 2026-08-28 07:00 | Confidential Client Asset

Creating and Dropping Databases and Tables in MySQL

Published July 26, 2025 By Sai Sree Ram Gundepudi

CREATE DATABASE

CREATE DATABASE inventory_db;

CREATE TABLE

CREATE TABLE products (
  id INT PRIMARY KEY,
  name VARCHAR(100),
  price DECIMAL(10,2)
);

DROP TABLE

DROP TABLE products;

DROP DATABASE

DROP DATABASE inventory_db;

Was this solution helpful?

Your feedback helps improve our technical knowledge repository.

Share this article

You may also like

CREATE and DROP Database/Table

Creating and Dropping Databases and Tables in MySQL

Create a DatabaseCREATE DATABASE school;Create a TableCREATE TABLE students ( id INT PRIMARY KEY, name VARCHAR(100),...