Products

Data Converter Cleaner TUC - Unit Converter Import Export Survey Manager Tweet Controller

Developer

Article Blog Forum Interview Beginner News Startup Quiz

Users

Career

Apply Job Internship

Pricing

Login Sign Up Get a Quote

Add column, with default value, to existing table in SQL Server

Anonymous User 3193 17 Apr 2013

Hi Everyone!

How do you add a column, with a default value, to an existing table in SQL Server 2000/2005?

Thanks in advance!

1 Answers

AVADHESH PATEL 17 Apr 2013

Hi Ashish!

You can try as below

ALTER TABLE {TABLENAME}

ADD {COLUMNNAME} {TYPE} {NULL|NOT NULL}

CONSTRAINT {CONSTRAINT_NAME} DEFAULT {DEFAULT_VALUE}

I hope it resolve your problem

MindStick Training

Markdown for AI

A clean, structured version of this page for AI assistants and LLMs.