Relationships

You can set up relations while creating tables such as:

create table table1

(col1 int primary key,

col2 int references table2(col2)...

)