A.2.19___A.2.20.docx

Data Definition Language (DDL) Statements

DDL statements enable creating, altering, and dropping schema objects like tables.

CREATE TABLE

DDL statement to create a new table with specified columns and data types.

ALTER TABLE

DDL statement to modify the structure of an existing table by adding or modifying columns.

RENAME

DDL statement to rename a table, view, sequence, or synonym with automatic transfer of constraints and grants.

DROP

DDL statement to remove tables, functions, procedures, views, synonyms, sequences, etc., from the database.

Data Manipulation Language (DML)

DML is used for retrieving, inserting, and modifying database information.

INSERT

DML command to add new records to a table.

SELECT

DML command to retrieve specific information from a database table.

UPDATE

DML command to modify existing data in a table based on specified conditions.

DELETE

DML command to remove records from a table based on specified conditions.