Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- CREATE TABLE R
- (
- a INT,
- b INT PRIMARY KEY DEFAULT 0,
- c INT
- );
- CREATE TABLE S
- (
- d CHAR,
- e INT CONSTRAINT ct REFERENCES R(b),
- f INT
- );
- GO
- INSERT INTO R VALUES
- (1, 6, 11),
- (2, 7, 12),
- (3, 8, 13),
- (4, 9, 14),
- (5, 10, 15);
- INSERT INTO S VALUES
- ('A', 6, 1),
- ('B', 7, 9),
- ('C', 7, 2),
- ('D', 9, 4),
- ('E', 8, 6);
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement