Dea917Mc

1IF OBJECT_ID('Employees') IS NOT NULL               
2DROP Table Employees                               
3
4CREATE TABLE Employees (
5eID int NOT NULL IDENTITY (1,1) PRIMARY KEY,
6eName varchar(255) NOT NULL,
7uID int NOT NULL,
8);
9
10IF OBJECT_ID('eA') IS NOT NULL /* checks if exists*/
11DROP Table eA                  /*removes */
12
13
14CREATE TABLE eA (
15aID int NOT NULL IDENTITY(1,1) PRIMARY KEY,
16
17eID int NOT NULL,
18CONSTRAINT FK_MadeUpName FOREIGN KEY (eID)
19REFERENCES Employees(eID),
20);
21
22ALTER TABLE [dbo].[eA] 
23 DROP CONSTRAINT [FK_MadeUpName]