Archives of the TeradataForum
Message Posted: Thu, 01 Oct 2009 @ 11:46:10 GMT
I have to alter the EMP_SALARY INTEGER to EMP_SALARY DECIMAL(18,0) without dropping the table. Also I cannot delete the records in the table.
Can someone help me in doing this modification to the below mentioned table.
CREATE SET TABLE SMART_APP.TEMP ,NO FALLBACK , NO BEFORE JOURNAL, NO AFTER JOURNAL, CHECKSUM = DEFAULT ( EMP_ID INTEGER, EMP_SALARY INTEGER ) PRIMARY INDEX ( EMP_ID );
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|