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

Add Column

• SQL Add Column operations

Alter Schema

CHECK Constraint

• Commonly used SQL Server Constraints: FOREIGN KEY, CHECK and DEFAULT

Computed Columns

• How to create indexes on SQL Server computed columns

Create

• CRUD operations in SQL Server

Create New Database

• Learn SQL: CREATE DATABASE & CREATE TABLE Operations

Create New Table

• Learn SQL: CREATE DATABASE & CREATE TABLE Operations

Create Schema

Delete

• CRUD operations in SQL Server
• Overview of the SQL Delete statement

DDL

• SQL DDL: Getting started with SQL DDL commands in SQL Server
• SQL Server lock issues when using a DDL (including SELECT INTO) clause in long running transactions

Drop Column

Drop Database

Drop Schema

Drop Table

• SQL DROP TABLE statement overview

Foreign key

• SQL Foreign key
• What is a foreign key in SQL Server

Identity Column

Modify Column

NOT NULL Constraint

• Constraints in SQL Server: SQL NOT NULL, UNIQUE and SQL PRIMARY KEY

PRIMARY KEY

• Constraints in SQL Server: SQL NOT NULL, UNIQUE and SQL PRIMARY KEY
• Learn SQL: Primary Key
• SQL Database design: Choosing a primary key

Rename Table

SELECT INTO

• SQL SELECT INTO statement

Sequence

• Difference between Identity & Sequence in SQL Server
• Sequence Objects in SQL Server
• Sequence objects feature in SQL Server

Synonym

• How to simplify SQL Server Database Object usage with Synonyms

Temporary Tables

• When to Use SQL Temp Tables vs. Table Variables

Truncate Table

• SQL truncate enhancement: Silent Data truncation in SQL Server 2019

UNIQUE Constraint

• Constraints in SQL Server: SQL NOT NULL, UNIQUE and SQL PRIMARY KEY

Update

• CRUD operations in SQL Server
• Overview of the SQL Update statement

• Author
• Recent Posts

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

Latest posts by SQLShack (see all)

• Best author award in 2021 - January 3, 2022
• Best author award in 2020 - January 5, 2021
• Best author award in 2019 - January 3, 2020