Create Table

CREATE TABLE dbo.StudentHistory
(

	StudentHistoryId int IDENTITY(1,1) NOT NULL,
	StudentId int NOT NULL,
	TermID int NOT NULL,
	ClassCode char(2) NULL,
	EnrolledCode char(1) NULL,
	TermCreditsAttempted int NULL,
	TermCreditsEarned int NULL,
	TermGPA numeric(4, 2) NULL,
	CumulativeCreditsEarned int NULL,
	CumulativeGPA numeric(4, 2) NULL,

	CONSTRAINT StudentHistory_PK PRIMARY KEY CLUSTERED 
	(
		StudentHistoryId ASC
	)

)