forum

Home / DeveloperSection / Forums / How to set default value for all tables column in SQL Server?

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

Anonymous User 2127 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!

mssql server

Updated on 04-May-2013

Anonymous User

I am a content writter !

Can you answer this question?

Answer

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!

forum

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

Anonymous User

1 Answers

Liked By