CREATE, ALTER, DROP

Published on: July 26, 2025 | Published by: Sai Sreeram Gundepudi

CREATE, ALTER, DROP Statements

CREATE

CREATE TABLE departments (
  dept_id NUMBER PRIMARY KEY,
  dept_name VARCHAR2(50)
);

ALTER

ALTER TABLE departments ADD location VARCHAR2(100);

DROP

DROP TABLE departments;

These commands are fundamental to managing schema objects in Oracle SQL.