DEFAULT Constraint In SQL Server 2008

In this article I am going to explain about DEFAULT Constraint in SQL.
  • 2068

Introduction

 With the help of default constraint we can insert a default value into a column.

The default value itself will be added to all new records, if  there is no other value specified.

Example

Suppose we create table named  Persons and the column names are: P_ID, LAST NAME, FIRST NAME,ADDRESS AND CITY. So here, the P_ID and the LASTNAME will have the NOT NULL values.

DEFAULT_constraint-in-sql.jpg

© 2019 DotNetHeaven. All rights reserved.