Results 1 to 4 of 4
  1. #1
    Join Date
    Mar 2002
    Posts
    1

    Design considerations of column nullability

    Personally, I try set all columns NOT null whenever possible.

    Any other ideas ?

  2. #2
    Join Date
    Mar 2001
    Location
    Lexington, KY
    Posts
    606
    Design to what your data dictates, although in most RDBMS's there is a slight performance and size advantage to NOT NULL, so I design NOT NULL where I can and only in certain cirucmstances do I use NULL.
    Thanks,

    Matt

  3. #3
    Join Date
    Jun 2002
    Location
    New York City
    Posts
    12

    Question Design considerations of column nullability

    What would you suggest for a datetime field where the value is not known and should therefore be not-applicable?

  4. #4
    Join Date
    Mar 2001
    Location
    Lexington, KY
    Posts
    606
    NULL sounds good to me.
    Thanks,

    Matt

Posting Permissions

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