Saturday 13 December 2014

Data Definition Language - DDL

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. Below are the most common DDL commands:
  • 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
  • No comments:

    Post a Comment