CREATE TABLE Students
(
StudentID int NOT NULL IDENTITY,
[Surname] varchar(100) NOT NULL,
[ChristianName] varchar(100) NOT NULL,
[Started] date,
Finished date,
Total int,
Test varchar(50),
CompanyID int NOT NULL,
PRIMARY KEY(StudentID),
FOREIGN KEY(CompanyID) REFERENCES Companies(CompanyID)
);