Not all columns can use the same template

Results create table Person ( Name char(100), ID number(),);alter table Person add primary key (ID);

Shouldn’t have

parentheses

or comma

Previous slide Next slide Back to first slide View graphic version

Notes:

Let’s look at the result the template and dictionary would generate at this stage of development, if run through the Intercalate engine. There are two things wrong with it.

The ID column doesn’t specify a size for the data. The size doesn’t appear in the output, but neither should it show the empty set of parentheses following the data type.

Also, commas are only used to separate elements in the column list in SQL. There should not be a comma following the last element.

Not all columns can use the same template

Results create table Person ( Name char(100), ID number(), ); alter table Person add primary key (ID);

Results create table Person ( Name char(100), ID number(),);alter table Person add primary key (ID);