Bazy 4

CREATE TABLE osoba3 (
ID INT PRIMARY KEY IDENTITY,
imie VARCHAR(50),
nazwisko VARCHAR(50) NOT NULL,
miasto VARCHAR(50),
adres VARCHAR(50),
data_ur DATE CHECK(data_ur >='1900-01-01' AND data_ur < '2100-12-31'),
nr_dowodu CHAR(10) UNIQUE,
statut VARCHAR(10) CHECK(statut IN ('student','emeryt','inny'))
);

INSERT INTO osoba3 VALUES ('Jan','Kot','Bielsko',NULL,'1920-05-02','AB0004','student');

INSERT INTO osoba3(nazwisko,nr_dowodu) VALUES ('Hipis','ABC123456');

INSERT INTO osoba3(nazwisko,nr_dowodu)
SELECT nazwisko,nr_dowodu
FROM Klient

DELETE FROM osoba3 WHERE ID=8
DELETE FROM osoba3


DROP TABLE osoba3