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?