2.1.07. SQL Create table

  • CREATE TABLE
    • <schema_name>.<relation_name>
    • (
      • <attribute_definitions>
      • <key>
      • <constraints>
    • )
  • CREATE TABLE example (Oracle)
  • Tables can (and should) be indexed by user
  • e.g. <username>.<tablename>
  • Normal login implies username
  • Non-local table access