Results 1 to 3 of 3
  1. #1
    Join Date
    Aug 2003
    Posts
    6

    Red face Unanswered: ALTER TABLE - Accept NULL Values???

    Hi,

    All i wanna do is to change a column to accept NULL values.

    the table was initially created to reject NULL values for this particualr column.

    cheers

    Nav

  2. #2
    Join Date
    Jul 2003
    Posts
    35
    Hi Nav,

    You can try...


    ALTER TABLE $tableName ALTER COLUMN $colName SET DEFAULT NULL;

    Chrs,
    Ash

  3. #3
    Join Date
    Aug 2003
    Posts
    6
    Thanks Ash

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •