maroph

Change Column to (NOT) NULL

Mar 2nd, 2016
348
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. -- change column FIELD in table TABNAME to not nullable
  2. ALTER TABLE TABNAME MODIFY FIELD NOT NULL;
  3. DESC TABNAME
  4. FIELD  NOT NULL ...
  5.  
  6. -- change column FIELD in table TABNAME to nullable
  7. ALTER TABLE TABNAME MODIFY FIELD NULL;
  8. DESC TABNAME
  9. FIELD           ...
Advertisement