Results 1 to 9 of 9

Thread: column

  1. #1
    Join Date
    May 2003
    Posts
    70

    Unanswered: column

    Hey,

    Is it possible to change a column's Allow Nulls property after the table is created?

    Thanks,

  2. #2
    Join Date
    Feb 2002
    Posts
    2,232
    Yes - using alter table. But you have to fill in null values with something if you are going from NULL to NOT NULL.

  3. #3
    Join Date
    Feb 2002
    Posts
    2,232
    FYI - If you have access to bol (Books Online), most of your questions could be answered - including the one you had earlier on primary key constraints.

  4. #4
    Join Date
    May 2003
    Posts
    70
    What's this books online???

  5. #5
    Join Date
    May 2003
    Posts
    70
    Oh yeah, and how would I do it using Alter Table??
    thanks,

  6. #6
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    If you have access to bol (Books Online)...
    everybody with an internet connection does, it's, um, online

    http://msdn.microsoft.com/library/en...server2000.asp

    for those without a 24/7 internet connection, you can also download BOL in case you want to look stuff up without dialing up...

    http://www.microsoft.com/sql/techinf...2000/books.asp


    rudy

  7. #7
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    Originally posted by vbgladiator
    Oh yeah, and how would I do it using Alter Table??
    thanks,
    http://msdn.microsoft.com/library/en...aa-az_3ied.asp

  8. #8
    Join Date
    Feb 2002
    Posts
    2,232
    Rudy - Thanks for posting those links.

    vbgladiator - BOL is an online technical reference utility for SQL Server. I would download it - that gives you guaranteed access. You will find that it is an indispensable reference for your SQL Server questions.

  9. #9
    Join Date
    May 2003
    Posts
    70
    already did

    Thanks a lot guys.

Posting Permissions

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