title: Modifying table in Teradata
body: <p>Hi Teradata colleagues!</p>
  
  <p>I have to do some modifications in production:
  1) Modify existing collumns
  2) Add some new collumns
  3) Drop and re-create primary index</p>
  
  <p>Can anyone help me in 1) case - modifying column segment with addition of compress part:</p>
  
  <p>segment CHAR(10) CHARACTER SET LATIN NOT CASESPECIFIC COMPRESS ('AM        ','CAM       ','KAM       ','KO        ','PSHC      ','RES       ','SBS       ')</p>
  
  <p>How to add this column:
  pot_klasse CHAR(1) CHARACTER SET LATIN NOT CASESPECIFIC COMPRESS ('B','U')</p>
  
  <p>How to make new index? (Do I have to drop it first and then make a new one?)</p>