Home > Alter, SQL Queries, SQL Server, T-SQL > Remove Not Null Constraint on a column using Alter Table statement

Remove Not Null Constraint on a column using Alter Table statement

Many times , it may be necessary to remove Not Null constraint used for a column in  a table. It is usually necessary to overcome unexpected integrity constraints ( rarely occurs, if designed well) against a table. We can remove the Not Null constaint by using  ALTER TABLE …. ALTER COLUMN … option.

A sample query to is as below

Continue Reading …

Advertisements
  1. October 21, 2010 at 12:50 pm

    You can edit audio files with audacity.

  2. October 27, 2010 at 5:08 am

    limewire is perfect

  3. April 10, 2013 at 3:56 am

    Elegant and often simple with crisp white icing and a few sprays
    of your favourite flowers, either fresh or sugar crafted, it will
    make a stunning impression. You will use this recipe time and again as
    it is really delicious and make a chocolate cake really special.

  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: