@chunliangl

When you deploy changes using a product rule in Pega, it can add new columns or increase the size of existing ones, but it won’t reduce a column size or delete a column. That’s because those actions could cause data loss, so Pega blocks them for safety. Even if you include the table class and mapping in the product rule, shrinking or removing columns won’t work. To do that, you’ll need to manually update the database using a SQL script or your DB admin tool after the deployment. This is a common limitation and not specific to your setup. If you're doing automated deployments, you can include the SQL as a separate step. Just make sure to test carefully, especially if there's existing data in the table.