List of articles   Terminology   Choose language


Replacement of 'create type' by 'create table'


Now expressions 'create table' and 'create type' are used as identical. This brings many people to incomprehension and hesitation, besides that presence of two expressions is redundant. Assotiation 'create table' with elementary datatypes like 'integer, real, char, varchar', generated by such interchangeablity, brings to cognitive dissonance. I propose to forbid expression 'create type', to define composed datatypes by expression 'create table', and to use term "type" for only elementary datatypes.

create table a (
  a1 num,
  a2 int,
  a3 num
);
create table b (
  b1 num,
  b2 int,
  b3 table a
);
--------------------------
| b1 | b2 |      b3      |
|------------------------|
|         | a1 | a2 | a3 |
|------------------------|
|                        |
|                        |
--------------------------


Dmitry Turin



List of articles   Terminology   Choose language


Сайт управляется системой uCoz