Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Wed, 14 Apr 2010 @ 13:45:59 GMT

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

Subj:   Re: Decimal(10,0)
From:   Baig, Mohammad

Hi Boris,

You can find all Rules for Changing the Column Data Type in SQL Reference: Data Definition Statements

Under the heading "Rules for Changing the Column Data Type" you can find all the rules for changing data type of a column And which data type can be changed to what and other rules.. :-) since OP was asking about DECI(10,0) TO DECI(15,0). just copied and pasted over here.. :-)

     Old Data Type   New Data Type   Restrictions on Changes
     DECIMAL(n,f)    DECIMAL(m,f)    Can change only as follows:
                                        * m >= n,    no change in f
                                        * n = 1 or 2, m < 3
                                        * n = 3 or 4, m < 5
                                        * n = 5 to 9, m < 10
                                        * n = 10 to 15, m <= 18

AND for more information Please refer to


This thread talks about the options for ALTER TABLE.

Thanks & Regards

Mohammad Usman Baig

  <Prev Next>   <<First <Prev Next> Last>>  
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 15 Jun 2023