sp_columns typename/data_type vs table designer: ntext vs nvarchar(MAX)

Viewed 235

In the Management Studio table designer, my table is nvarchar(MAX), but in sp_columns, it says TYPE_NAME = ntext and DATA_TYPE = -10.

Which is correct? (I want to avoid ntext for future compatibility)

1 Answers
Related