Discussion2Replies2171Views SathyaG_Incessant Member since 2014 3 posts INCESSANT TECHNOLOGIES Posted: 4 years agoLast activity: 4 years 3 months ago Closed Alter DB column size while Optimizing PropertiesIn PEGA 7, When i optimize a text property, I don't see any options to set the size of it.By default It is created as Varchar(32). What should i do if i want to create them as VarChar(max) when i optimize it? RegardsSathya G Data Integration ×Close popoverFacebookTwitterLinkedinEmail Copy Link Copied! Moderation Team has archived post This thread is closed to future replies. Content and links will no longer be updated. If you have the same/similar Discussion, please write a new Discussion. Posted: 4 years agosahup1 PEGA replied to SathyaG_Incessantcould you please check if the property is defined with max length under advanced tab? or if blank by adding some length helps in generating the required SQL? Posted: 4 years agoRaviP@incessant NIIT Technologies Limited replied to SathyaG_IncessantHi Sathya, Do you have database access? If yes, go to database and alter the column length to varchar(max), then resave the corresponding Data-Admin-DB-Table instance, this should work.