How can I create a CDT from Table which has a one of the columns as type TEXT

Question

HI 
 How can we create a CDT for a table which has type TEXT for one of the column. I created a below as an example.

When I tried to import the above table to a CDT using create from database table or view, I see the below error. Is there any way we can achieve this scenario?

Thanks in advance 
 
 FYI 
 Initially tsetField3 is of type varchar and later I have changed it to TEXT in DB.

Josh · Accepted Answer

You can use TEXT columns, you need to manually update the xsd to use @Column(columnDefinition = "TEXT") for the desired column.

Chris · Answer

Unfortunately TEXT columns are not supported. We use varchar(max) instead. Note that MSDN has made it aware that TEXT types will be removed in a future version of SQL Server. 
 
Courtesy of docs.microsoft.com/.../ntext-text-and-image-transact-sql 
 
IMPORTANT! ntext, text, and image data types will be removed in a future version of SQL Server. Avoid using these data types in new development work, and plan to modify applications that currently use them. Use nvarchar(max), varchar(max), and varbinary(max) instead.

How can I create a CDT from Table which has a one of the columns as type TEXT

Top Replies