WRUn15XY

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