SQL Server Interview Question #11

What is DDL?

SQL Server Fundamentals Junior Beginner

Detailed Explanation

DDL stands for Data Definition Language. It is used to create, alter, or remove database structures such as tables and other database objects. Common DDL statements include CREATE, ALTER, and DROP.

Code Example

CREATE TABLE Employees
(
    Id INT PRIMARY KEY,
    Name NVARCHAR(100) NOT NULL
);

ALTER TABLE Employees
ADD Email NVARCHAR(200);