Default Constraint

 Default Constraint

 -it can be used default value to insert in the column

 Example 1:

 create table Person(id int,city varchar(20) Default 'INDIA')

 insert into Person values(1,default)

 select * from Person

 Example 2:

 create table PerDate(id int,Date Date Default getdate())

 insert into PerDate Values(1,Default)

 select * from PerDate

Browse More Articles

Tweet

Written by Test

We are Creative Blogger Theme Wavers which provides user friendly, effective and easy to use themes. Each support has free and providing HD support screen casting.