Re: [Emerald] region size

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

Messages sorted by: [ date ][ thread ][ subject ][ author ]
Previous message: Nada Syriani: "[Emerald] region size"
Next message: Rick Knospler: "[Emerald] Emerald Check Database errors"
Maybe in reply to: Nada Syriani: "[Emerald] region size"

From: Nada Syriani <nadas@inco.com.lb>
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
following:

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

update masteraccounts
set region = regionold

Josh

For more information about this list, including removal,
please see http://www.iea-software.com/maillist.html

Previous message: Nada Syriani: "[Emerald] region size"
Next message: Rick Knospler: "[Emerald] Emerald Check Database errors"
Maybe in reply to: Nada Syriani: "[Emerald] region size"