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

How to set default value for all tables column in SQL Server?

Anonymous User 2575 04 May 2013

Hi!
How to set default value for all tables column in SQL Server?
If it is string it will empty and if it is int in already created table.
Thanks in advance!

1 Answers

AVADHESH PATEL 04 May 2013

Hi Jayprakash!

Add DEFAULT constraint

Here is the way to do it:

CREATE TABLE Persons
(
id int NOT NULL,
LName varchar(25) NOT NULL,
FName varchar(25),
Addr varchar(255),
City varchar(255) DEFAULT 'Hawaii'
)

I hope it solve your problem!

advertising

Markdown for AI

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