|< < 3 > >|

Views

Scripts: See view.sql.

A view is an unevaluated SQL statement that is treated like a table for purposes of querying.

Example


create table department(
    dept_id int not null primary key,
    name varchar not null
);

create table all_student(
    student_id int not null check(student_id > 0) primary key,
    name varchar not null,
    enroll_date date not null check(enroll_date > '1900/01/01'::date),
    graduation_date date check(graduation_date > '1900/01/01'::date),
    dept_id int references department
);

|< < 3 > >|