Re: [ADMIN] alter table alter column to resize a varchar

2012-10-01 Thread Gary Stainburn
On Thursday 27 September 2012 15:49:53 Craig James wrote: > On Thu, Sep 27, 2012 at 2:23 AM, Gary Stainburn > > wrote: > > Hi folks. > > > > I'm planning on extending a field in one of my main tables using: > > > > alter table stock alter column type varchar(255); > > Why not just do > >alter

Re: [ADMIN] alter table alter column to resize a varchar

2012-09-27 Thread Craig James
On Thu, Sep 27, 2012 at 2:23 AM, Gary Stainburn wrote: > Hi folks. > > I'm planning on extending a field in one of my main tables using: > > alter table stock alter column type varchar(255); Why not just do alter table stock alter column type text; That is, do you really need a limit? The

[ADMIN] alter table alter column to resize a varchar

2012-09-27 Thread Gary Stainburn
Hi folks. I'm planning on extending a field in one of my main tables using: alter table stock alter column type varchar(255); to extend it from the current varchar(80). My concern is that this table and this field is used in a number of views, and views of views. Are then any gotchas that I n