Expand|Select|Wrap|Line Numbers
- 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.