Archives of the TeradataForum

Message Posted: Thu, 14 Dec 2006 @ 22:22:08 GMT


	<Prev	Next>		<<First	<Prev	Next>	Last>>

Subj:		Re: Widen a column length with the ALTER TABLE

From:		Vinay Bagare

Hope this helps ..

     create table test ( sno int, addr varchar(10)) primary index (sno);
     show table test;
     Request Text
     CREATE SET TABLE DBA_DB.test ,NO FALLBACK ,
     NO BEFORE JOURNAL,
     NO AFTER JOURNAL,
     CHECKSUM = DEFAULT
     (
     sno INTEGER,
     addr VARCHAR(10) CHARACTER SET LATIN NOT CASESPECIFIC)
     PRIMARY INDEX ( sno );


     alter table test add addr varchar(200)

Thanks,

Vinay Bagare