Code:
CREATE TABLE Upload ( uploadid INT IDENTITY(1,1) PRIMARY KEY, cssid INT NOT Null FOREIGN KEY REFERENCES CourseSemSub(cssid), teacherid VARCHAR(10) NOT NULL FOREIGN KEY REFERENCES Teacher(teacherid), description VARCHAR(40), video VARBINARY(MAX) NOT NULL )
Msg 170, Level 15, State 1, Line 7
Line 7: Incorrect syntax near 'MAX'.
Details:
Upload is the table in my database & CourseSemSub, Teacher are the two other tables earlier created.
I want to store video files in the video field in this Upload table. So i'm trying to make it varbinary(max)[as large as possible] but i'm unable to create the table using above code.
Comment