Archives of the TeradataForum

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

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

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

www.teradataforum.com/teradata/20030528_141438.htm

This thread talks about the options for ALTER TABLE.

Thanks & Regards

Mohammad Usman Baig
ECRIS RETAIL MODELING TEAM
CONTRACTOR-TCMS.

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