Re: [Emerald] region size

Josh Hillman ( (no email) )
Wed, 3 Mar 1999 10:47:10 -0500

From: Nada Syriani <>
What we need to do is to change the size of the region field to
varchar 40. How can we implement this using SQL 6.5

The existing column cannot be resized or deleted, so you'll have to do the

Rename the existing Region column to RegionOld.
Create a new column called Region of type varchar(40).

update masteraccounts
set region = regionold


For more information about this list, including removal,
please see