Results 1 to 3 of 3
  1. #1
    Join Date
    Feb 2004
    Posts
    139

    Unanswered: Required field in SQL Server 2003 table

    I am a newbie to SQL Server as I have my front end in Access and upsized the table to SQL Server. I would like to make a field into a required field. I knew how to set a field in SQL to be required.

    Appreciate any help!

    Thanks,
    B&R

  2. #2
    Join Date
    Feb 2004
    Location
    One Flump in One Place
    Posts
    14,912
    I suspect you mean SQL Server 2005

    Code:
    ALTER TABLE dbo.mytable
    ALTER COLUMN mycolumn INT /*OR WHATEVER YOUR CURRENT DATA TYPE IS*/ NOT NULL

  3. #3
    Join Date
    Feb 2004
    Posts
    139
    Not Null was the answer. Appreciate your help.

    B&R

Posting Permissions

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