Data Definition (DDL)

• Users and Databases
  • CREATE USER
  • DROP USER
  • ALTER USER
  • CREATE DATABASE
  • DROP DATABASE
  • Basic Database Security Example
• Tables
  • CREATE TABLE
  • CREATE TABLE AS SELECT
  • ALTER TABLE
  • DROP TABLE
  • TRUNCATE TABLE
• Views
  • CREATE VIEW
  • DROP VIEW
• Datatypes and Fixed Encoding
  • Shared Dictionaries