P04.sql

CREATE TABLE [Minions](
	[Id] INT PRIMARY KEY,
	[Name] NVARCHAR(50) NOT NULL,
	[Age] INT NOT NULL
)

CREATE TABLE [Towns](
	[Id] INT PRIMARY KEY,
	[Name] NVARCHAR(70) NOT NULL
)


ALTER TABLE [Minions]
ADD [TownId] INT FOREIGN KEY REFERENCES [Towns]([Id]) NOT NULL

ALTER TABLE [Minions]
ALTER COLUMN [Age] INT 

GO

INSERT INTO [Towns]([Id],[Name])
	VALUES
(1,'Sofia'),
(2,'Plovdiv'),
(3,'Varna')

INSERT INTO [Minions]([Id],[Name],[Age],[TownId])
	VALUES
(1,'Kevin',22,1),
(2,'Bob',15,3),
(3,'Stewart',NULL,2)


DELETE FROM [Minions]

DROP TABLE [Minions]
DROP TABLE [Towns]