Data Definition

• Table Basics
  • Creating Tables
  • Deleting Tables
• Default Values
• Generated Columns
  • Rules
• Constraints
  • 1. Check Constraints
  • 2. Not-Null Constraints
  • 3. Unique Constraints
  • 4. Primary Keys
  • 5. Foreign Keys
  • 6. Exclusion Constraints
• System Columns
• Modifying tables
  • 1. Adding a Column
  • 2. Removing a Column
  • 3. Adding a Constraint
  • 4. Removing a Constraint
  • 5. Changing a Column’s Default Value
  • 6. Changing a Column’s Data Type
  • 7. Renaming a Column
  • 8. Renaming a Table
• Privileges
  • Demo
  • Access Control List (ACL) Privilege Abbreviations
  • Summary of Access Privileges
• Schemas
  • Creating a Schema
  • Deleting a Schema
  • The Schema Search Path
  • Privileges
  • The System Catalog Schema
  • Usage Patterns