SQL Server Documentation - Data Definition Language (DDL)

Introduction to DDL

Data Definition Language (DDL) is a set of commands used to create, modify, and delete database objects.

Common DDL Commands

CREATE TABLE

`CREATE TABLE Customers (
    CustomerID INT PRIMARY KEY,
    FirstName VARCHAR(255),
    LastName VARCHAR(255),
    City VARCHAR(255)
);`

`ALTER TABLE Customers
ADD Email VARCHAR(255);`

`DROP TABLE Customers;`

Further Resources

For more detailed information, please refer to the official Microsoft documentation: