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

SQLShack

SQL Shack was created as a community service from ApexSQL, with the goal to share SQL Server knowledge through articles written by SQL Server professionals and community members
SQLShack

Latest posts by SQLShack (see all)