<div>
I think only XML, and spatial data types, geometry and geography, are implemented as CLR in SQL server. All the others are native SQL. The thing with varchar and nvarchar (max) is that they are now used instead of the deprecated image, text and ntext types.
</div>


I think only XML, and spatial data types, geometry and geography, are implemented as CLR in SQL server. All the others are native SQL. The thing with varchar and nvarchar (max) is that they are now used instead of the deprecated image, text and ntext types.

<div>
What i need is the names for those types so I could query sys tables for them
</div>


What i need is the names for those types so I could query sys tables for them

<div>
<div class="content wysiwyg-content">
Can someone name the large CLR types for me? Are nvarchar(max), varchar(max) etc. considered large CLR types?
</div>
</div>


Can someone name the large CLR types for me? Are nvarchar(max), varchar(max) etc. considered large CLR types?

large CLR types on SQL Server

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.