Data Definition Language DDL

Data Definition Language (DDL) refers to Data Definition Statements.
Create a database

CREATE DATABASE [Database_Name];

Delete a database

DROP DATABASE [Database_Name];

Table Related Operations

Create a table

<!-- [] indicates that the following content is optional -->
CREATE TABLE <Table_Name>
    (<Column_Name><Data_Type>[Column-Level Integrity Constraints]
    [, <Column_Name><Data_Type>[Column-Level Integrity Constraints]]...
    [, <Table-Level Integrity Constraints>]);

Modify a table

ALTER TABLE <Table_Name>
    [ADD<Column_Name><Data_Type>[Column-Level Integrity Constraints]]
    [DROP<Integrity_Constraint_Name>]
    [MODIFY<Column_Name><Data_Type>];

Delete a table

DROP TABLE <Table_Name>

Indexes

Create an index

CREATE[UNIQUE][CLUSTER]INDEX<Index_Name>
    ON<Table_Name>(<Column_Name>[<Order>]
        [<Column_Name>[<Order>]]...);

Delete an index

DROP INDEX <Index_Name>

Views

Create a view

CREATE VIEW View_Name AS SELECT Statement;

Delete a view

DROP VIEW View_Name;