We are half-way done with the course. We are now creating, dropping and altering objects.

    CREATE  obj_type   obj_name [some_code]

    CREATE  DATABASE   db_name;

    CREATE  SCHEMA     schema_name;

    CREATE  TABLE      table_name;
      (
        field_1 datatype_1 [atributes],
        field_2 datatype_2 [atributes],
        field_3 datatype_3 [atributes],
        ...
      );

    CREATE  VIEW       view_table
    AS
      (
        SELECT fields...
        FROM table(s)
      );

Download the class notes for day 6.

This entry is licensed under a Creative Commons Attribution-NonCommercial-ShareAlike 4.0 International license.