Identify attributes of the first column

Template create table $table$ ( Name char(100), ID number);alter table $table$ add primary key (ID);

Previous slide Next slide Back to first slide View graphic version

Notes:

We proceed to identify the next piece of information specific to this table that we wouldn’t expect to occur universally in other table creation scripts. The fact that the Person table has a column called Name is clearly not a general characteristic of all tables.

The Name column similarly has characteristics, specifically the data type and size information, that are specific to that column. We extract all these pieces of information and give them each individual keys in the dictionary.

Identify attributes of the first column

Template create table $table$ ( Name char(100), ID number ); alter table $table$ add primary key (ID);

Template create table $table$ ( Name char(100), ID number);alter table $table$ add primary key (ID);