Identify occurrences of the table name
Prototype create table Person ( Name char(100), ID number ); alter table Person add primary key (ID);
Notes:
The Intercalate analysis process starts with a prototype of the text we want the template and dictionary to represent and to generate. For this tutorial we will use as an example a snippet of SQL which creates a table called Person having two columns, Name and ID. The Name column can hold up to 100 alphanumeric characters. The ID column is strictly numeric and serves as a primary key.
Much of the text in this prototype would also be present in the SQL used to create any other table. To take advantage of this, we use the prototype as the first step in the evolution of a general template.
The steps in the Intercalate modeling process are to incrementally identify words specific to this table and move them to the dictionary, leaving a keyword behind in the template to show where they should go.
The table name, Person, highlighted here in red, is the first and most obvious example of a feature that would be specific to the Person table.