    @Test
    public void shouldParseSql92CreateSchema() throws Exception {

        database = parser.parse(testFile("create_schema.ddl"));
        assertThat(database.getName(), is("POSTGRES"));
        Schema schema = database.getSchema("hollywood", false);
        assertThat(schema.getName(), is("hollywood"));
        Table table = schema.getTable("films", false);
        assertThat(table.getName(), is("films"));
        Iterator<Column> columns = table.getColumns().values().iterator();
        assertColumn(columns.next(), "title", "VARCHAR", null, 255, 0, 0);
        assertColumn(columns.next(), "release", "DATE", null, 0, 0, 0);
        assertColumn(columns.next(), "producerName", "VARCHAR", null, 255, 0, 0);
        assertThat(columns.hasNext(), is(false));

        View view = schema.getView("winners", false);
        assertThat(view.getName(), is("winners"));
        assertThat(view.expression, is("CREATE VIEW winners AS SELECT title, release FROM films WHERE producerName IS NOT NULL;"));
    }