Skip to content

CREATE SCHEMA Example

Create a schema for the accounting user:

CREATE SCHEMA AUTHORIZATION accounting       CREATE TABLE employees (lname CHAR(30) NOT NULL,              fname CHAR(30) NOT NULL,              salary MONEY,              dname CHAR(10)                      REFERENCES dept(deptname),              PRIMARY KEY (lname, fname))       CREATE TABLE dept(deptname CHAR(10) NOT NULL UNIQUE,       location CHAR(15),       budget MONEY,       expenses MONEY DEFAULT 0)       CREATE VIEW mgr(mlname, mfname, mdname) AS         SELECT lname, fname, deptname FROM employees,dept           WHERE dname = deptname       GRANT REFERENCES(lname, fname)          ON TABLE employees TO harry;