We have finally gotten our feet wet creating database objects.
CREATE data_obj data_name [code]; CREATE DATABASE db_name; -- no extra code CREATE SCHEMA schema_name; -- no extra code CREATE TABLE table_name -- code for structure ( field1 data_type [arguments], field2 data_type [arguments] ); CREATE VIEW view_name -- code for structure AS SELECT field1, field2 FROM table1;
Download the class notes for day 6.