38. Data Definition Language

Data Definition Language

Data Definition Language (DDL) is used by SQL

to create, modify, and remove object definitions:

DDL Statements:

Databases :

    CREATE DATABASE

    MODIFY DATABASE

    DROP DATABASE

Users CREATE USER

    MODIFY USER

    DROP USER

Tables

      CREATE TABLE

      ALTER TABLE

      DROP TABLE

Views

    CREATE VIEW

    REPLACE VIEW

    DROP VIEW

Macros

   CREATE MACRO

   REPLACE MACRO

   DROP MACRO

Indexes

    CREATE INDEX

    DROP INDEX