Archives of the TeradataForum

Message Posted: Wed, 07 Dec 2005 @ 13:23:53 GMT

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

You can use the ADD command of the ALTER statement to increase the size of the column... This acts as the MODIFY statement.

Decreasing the size of the column is a different story. It does not appear to like decreasing the size of the column.

     CREATE TABLE STATEMENT:

     CREATE SET TABLE DBNAME.TABLENAME,
     NO FALLBACK ,
     NO BEFORE JOURNAL,
     NO AFTER JOURNAL
     (
     A_ID INTEGER NOT NULL,
     MILSTN_TX VARCHAR(10) CHARACTER SET LATIN NOT CASESPECIFIC NOT NULL,
     )
     PRIMARY INDEX INDEX_NM ( A_ID);

     ALTER STATEMENT:
     ALTER TABLE DBNAME.TABLENAME
       ADD COLUMNNAME VARCHAR(20);

Chris Coffing

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