Data Definition Language

SQL > Data Definition Language - DDL

Data Definition Language (DDL) is a part of SQL that is used to create, modify, and delete database objects such as table, view, and index, and to manage access privileges to these objects. Below are the most common DDL commands:

SQL CREATE TABLE

SQL Data Types

Next: SQL CREATE TABLE

This page was last updated on April 30, 2022.

SQL Tutorial
Basic SQL Commands
SQL SELECT
SQL DISTINCT
SQL WHERE
SQL AND OR
SQL IN
SQL BETWEEN
SQL Wildcard
SQL LIKE
SQL ILIKE
SQL ORDER BY
SQL GROUP BY
SQL HAVING
SQL ALIAS
SQL AS
SQL SELECT UNIQUE
SQL JOIN
SQL INNER JOIN
SQL OUTER JOIN
SQL LEFT OUTER JOIN
SQL CROSS JOIN
SQL INSERT INTO
SQL INSERT INTO SELECT
SQL UPDATE
SQL DELETE FROM
Advanced SQL
SQL UNION
SQL UNION ALL
SQL Inline View
SQL INTERSECT
SQL MINUS
SQL LIMIT
SQL TOP
SQL Subquery
SQL WITH
SQL EXISTS
SQL CASE
Window Functions
SQL DECODE
SQL AUTO INCREMENT
SQL IDENTITY
SEQUENCE & NEXTVAL
SQL Functions
SQL Average
SQL COUNT
SQL MAX
SQL MIN
SQL SUM
SQL ROUND
String Functions
SQL CAST
SQL CONVERT
SQL CONCATENATE
SQL SUBSTRING
SQL INSTR
SQL TRIM
SQL LENGTH
SQL REPLACE
SQL TO_DATE
Date Functions
SQL DDL
SQL CREATE TABLE
SQL Data Types
SQL View
SQL CREATE VIEW
SQL Index
SQL CREATE INDEX
SQL DROP TABLE
SQL TRUNCATE TABLE
SQL USE
SQL CREATE DATABASE
SQL DROP DATABASE
SQL GRANT
SQL REVOKE
SQL CONSTRAINT
NOT NULL Constraint
DEFAULT Constraint
UNIQUE Constraint
CHECK Constraint
PRIMARY KEY
FOREIGN KEY
SQL ALTER TABLE
Add Column
Change Column
Modify Column
Rename Column
Drop Column
Add Index
Drop Index
Add Constraint
Drop Constraint
SQL NULL
SQL ISNULL Function
SQL IFNULL Function
SQL NVL Function
SQL Coalesce Function
SQL NULLIF Function
SQL Video Tutorial
SQL Syntax
SQL Quiz
Sitemap
Resources