Re: Changing column width of full table?

billyoc_at_iii.net (Billy O'Connor) wrote:

>Can I change the width of a column in a table that's loaded with
>2 million records? Please?<g>

>/* Billy O'Connor email: billyoc_at_iii.net
> D.P.S. Consulting, Boston MA CIS: 74021,530
> Boston area OS/2 business solutions */

I believe you can change the width of attributes of data types CHAR and NUMBER anytime using ALTER TABLE ...MODIFY

Hope this helps.

//************************************************************************//
// Raghu Valluri                                                          //   
// Synon Inc.,                                                            //   
// 1100, Larkspur Landing Circle                                          //
// Larkspur, CA 94939                                                     //
// (415) 461-5000                                                         // 
// email: rnv_at_synon.com                                                   //
//************************************************************************//