USE master; GO IF db_id (N'lab131') IS NOT NULL DROP DATABASE lab131; GO CREATE DATABASE lab131 ON (NAME = dat_lab131, FILENAME = 'C:\data\datlab131.mdf', SIZE = 10MB, MAXSIZE = 50MB, FILEGROWTH = 5MB) LOG ON (NAME = log_lab131, FILENAME = 'C:\data\loglab131.ldf', SIZE = 5MB, MAXSIZE = 25MB, FILEGROWTH = 5MB); GO IF db_id (N'lab132') IS NOT NULL DROP DATABASE lab132; GO CREATE DATABASE lab132 ON (NAME = dat_lab132, FILENAME = 'C:\data\datlab132.mdf', SIZE = 10MB, MAXSIZE = 50MB, FILEGROWTH = 5MB) LOG ON (NAME = log_lab132, FILENAME = 'C:\data\loglab132.ldf', SIZE = 5MB, MAXSIZE = 25MB, FILEGROWTH = 5MB); GO USE lab131; GO CREATE TABLE Person (idofperson int PRIMARY KEY CHECK (idofperson < 100), firstname char(50) NOT NULL, secondname char(50) NOT NULL); GO USE lab132; GO CREATE TABLE Person (idofperson int PRIMARY KEY CHECK (idofperson >= 100), firstname char(50) NOT NULL, secondname char(50) NOT NULL); GO USE master; GO CREATE VIEW view_Person_131_132 AS SELECT * FROM lab131.dbo.Person UNION ALL SELECT * FROM lab132.dbo.Person; GO INSERT view_Person_131_132 (idofperson, firstname, secondname) VALUES (1, 'Regina', 'Frank'), (2, 'Lola', 'Moon'), (3, 'James', 'Cost'), (200, 'James', 'Cost'); GO DELETE view_Person_131_132 WHERE idofperson = 2; GO UPDATE view_Person_131_132 SET idofperson = 201 WHERE idofperson = 3; GO SELECT * FROM view_Person_131_132; GO SELECT * FROM lab131.dbo.Person; GO SELECT * FROM lab132.dbo.Person; GO DROP VIEW view_Person_131_132; DROP TABLE lab131.dbo.Person; DROP TABLE lab132.dbo.Person; DROP DATABASE lab131; DROP DATAbASE lab132; GO