title: Add a column not null without default
body: <p>When I try to add this column:<br/></p>
  
  <blockquote>
    <p>alter table APL ADD CODE NUMERIC(2) NOT NULL <br/> 
    <br/></p>
  </blockquote>
  
  <p>I get this error:</p>
  
  <blockquote>
    <p>ALTER TABLE 'APL 'failed. Default clause is required in order to add non-NULL column 'CODE'.
    <br/></p>
  </blockquote>
  
  <p>I know I can add a default and it will work, but I DONT WANT A DEFAULT VALUE in this coloumn, i read and i heard that there is way that i can add the column with out a default.<br/>
  anyone knows how ?<BR/></p>
  
  <hr>
  
  <p>Edit:<br/>
  Ill explain more about my case.<br/>
  This column was created by mistake as NULL(I dont know why), and its part of primary key(luckily I have no duplicate), so I have to change it to NOT NULL , so I can assign it .<br/> Its really an old column and I dont know what kind of default I should add, because if I add a wrong value the applications might cause problems.</p>