• DATABASE: foo
  • INDEX: Improve query performance
  • VIEW: Virtual table based on the result of a query
  • FUNCTION: foo
  • SCHEMA: Logical grouping of database objects
  • TRIGGER: Set of actions executed automatically in response to certain events
  • PROCEDURE: Reusable set of SQL statements stored in the database
  • USER (or ROLE in PostgreSQL): User/role for managing database privileges
  • EVENT: Scheduled event to execute at specified times (MySQL)
  • TEMPORARY TABLE: Temporary table that exists for teh duration of a session or transaction (PostgreSQL or Oracle)
  • SEQUENCE: Sequence object to generate unique numeric values (PostgreSQL or Oracle)
  • TYPE: Data type similar to classes (PostgreSQL)
  • DOMAIN: Data type with constraints (PostgreSQL)
  • ASSERTION: Database-wide constraint (rarely implemented)