tsql: Find varchar or nvarchar(max)

From time to time I need to find all fields in a database that are varchar or nvarchar(max).  Following is a little bit of code that I come back to time and again, sharing it for you (and so I can find it next time I need it!) .

 

 

Leave a Reply

Your email address will not be published. Required fields are marked *