Archives of the TeradataForum

Message Posted: Fri, 15 Dec 2006 @ 13:10:15 GMT

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

<-- Anonymously Posted: Friday, December 15, 2006 04:28 -->

Hello,

So is this metod valid for changing lenghts or types of columns? Surely one does not have to rebuild the table to achieve this?

I often have requirements to change the DataType or Length of DataType.

Par exemple:

     create table test ( sno int, addr varchar(10), sno1 decimal(16,2))
     primary
     index (sno);

     show table test;


     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)
     sno INTEGER,
     PRIMARY INDEX ( sno );


     alter table test add sno1(decimal(18,4));

Regards

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