Toad World® Forums

Can Toad for SQL Server be made to use VARCHAR(MAX)/NVARCHAR(MAX) instead of Text?

I’ve noticed that when my boss uses Toad for SQL Server and he wants to generate a string field with in essense an infinite length, that it generates it using the data type text. Here’s an example of a very simple table, where the field name Comments illustrates what I’m talking about:

CREATE TABLE SomeTable ( Id Int IDENTITY(1,1) NOT NULL, Comments text NULL, CONSTRAINT IX_Id PRIMARY KEY CLUSTERED ( Id ASC ) )

The data type VARCHAR(MAX) (or NVARCHAR(MAX)) is favored over the older data type text (or ntext). Is there a way of making Toad for SQL Server generate VARCHAR(MAX)/NVARCHAR(MAX) when generating the code that it does to create/modify a table?

Hi Rob,

Sorry about that I am not fully understand what you described. But when you create/modify a table, you can choose data type what you want