홈


Reference of SQLEssentials


의견 전하기


:: SQL ::

DDL (Data Definition Language)

  • CREATE DATABASE
  • DROP DATABASE
  • CREATE TABLE
  • ALTER TABLE
  • DROP TABLE
  • CREATE INDEX
  • DROP INDEX
  • CREATE VIEW
  • CREATE OR REPLACE VIEW
  • DROP VIEW

DML (Data Manipulation Language)

  • SELECT
  • INSERT INTO
  • UPDATE
  • DELETE
  • TRUNCATE

DCL (Data Control Language)

  • GRANT
  • REVOKE