Default Constraint

[robert030975]

HI

Was looking at creating a table where to use the default constraint.

CREATE TABLE Customer
(
CustomerID INT CONSTRAINT pk_customer_cid PRIMARY KEY,
CustomerName VARCHAR(30),
CustomerAddress VARCHAR(50) CONSTRAINT df_customer_Add DEFAULT 'UNKNOWN'
)


If I insert

Insert into Customer
Values ( 113, NULL,NULL)


select * from Customer

The customer adress comes up as NULL as opposed to 'UNKNOWN'


I thought about specifying


CustomerAddress VARCHAR(50) CONSTRAINT df_customer_Add NULL DEFAULT 'UNKNOWN'

but still does not work. Am i doing something wrong?

 

[fredericofonseca]

try
Insert into Customer (CustomerID , CustomerName )
Values ( 113, NULL)

Regards

Frederico Fonseca
SysSoft Integrated Ltd

http://www.syssoft-int.com

FAQ219-2884
FAQ181-2886

 

[Qik3Coder]

To clarify why Frederico's solution will work:
A default constraint is used when no value is specified. You had explicitly indicated you wanted a NULL value.

I've found default constraints seem to be designed for "extending" your database, without extending your code base. The code doesn't know about the new field, so doesn't try to put anything in, and then gets the default value.

Lodlaiden

You've got questions and source code. We want both!
Here at tek tips, we provide a hand up, not a hand out.