Data Definition Language (DDL)

This page explores the useful Data Definition Language (DDL) commands such as Create, Drop, Alter with examples.

Add Column

Alter Schema

CHECK Constraint

Computed Columns

Create

Create New Database

Create New Table

Create Schema

Delete

DDL

Drop Column

Drop Database

Drop Schema

Drop Table

Foreign key

Identity Column

Modify Column

NOT NULL Constraint

PRIMARY KEY

Rename Table

SELECT INTO

Sequence

Synonym

Temporary Tables

Truncate Table

UNIQUE Constraint

Update


SQLShack
Latest posts by SQLShack (see all)