SQL Server CE - Not letting me add a Varbinary column of max length

Question

I've been struggling in vain to add a VARBINARY column of MAX length to my table.

I'm trying with this:

ALTER TABLE Databases ADD dbFile VARBINARY(MAX)

and it's returning:

There was an error parsing the query. [ Token line number = 1,Token line offset = 44,Token in error = MAX ]

What am I doing wrong?

Answer 1

According to this TechNet page (Data Types Supported in SQL Server CE), SQL Server CE supports varbinary only up to 8000 bytes long.

If you need a larger column, you have to use image instead.