Schema Definition Language

• Describing Databases with MetaData
  • Creating and Dropping Database Tables
  • Specifying the Schema Name
    • Applying Dynamic Schema Naming Conventions
  • Backend-Specific Options
• Reflecting Database Objects
  • Reflecting Views
  • Fine Grained Reflection with Inspector
  • Limitations of Reflection
• • Python-Executed Functions
  • Client-Invoked SQL Expressions
  • Marking Implicitly Generated Values, timestamps, and Triggered Columns
  • • Associating a Sequence on a SERIAL column
    • Associating a Sequence with the MetaData
  • Computed Columns (GENERATED ALWAYS AS)
  • Default Objects API
• • Defining Foreign Keys
    • ON UPDATE and ON DELETE
  • PRIMARY KEY Constraint
  • Configuring Constraint Naming Conventions
    • The Default Naming Convention
    • Creating Custom Tokens for Naming Conventions
    • Configuring Naming for Boolean, Enum, and other schema types
  • Indexes
  • Index API
• • Custom DDL
  • Using the built-in DDLElement Classes