C# Tutorials and offshore development in India

Prizes & Awards

My Profile

AdSense Revenue

Active Members
Today

Bunty (130)
Murali (122)
SweetGhost (96)

Last 7 Days

more...

New Feature: Community Sites: Create your own .NET community website and start earning from Google AdSense ! It's Free !

How to create default constraint over column in a Table

Posted Date: 13 Jun 2008 Resource Type: Code Snippets Category: SQL Schema

Posted By: Jins Philip Member Level: Gold
Rating:

Points: 10

This is a handy script, for creating default constraint over column in a Table


ALTER TABLE Employee
            ADD CONSTRAINT DF_Employees_Name
            DEFAULT 'UNKNOWN' FOR Name

Responses

Author: Kapil Dhawan 18 Jun 2008 Member Level: Gold Points : 2

Hello
Nice piece of code
Thanks for sharing your knowledge with us.
I hope to see more good code from your side
This code will help lots of guys
Thanks to you
Regards,
Kapil

Author: Shivshanker Cheral 18 Jun 2008 Member Level: Diamond Points : 0

Thanks for sharing

Author: Bunty 27 Jun 2008 Member Level: Diamond Points : 2

Hi,

Ausum code to create a default constraint on a column of a table.

This code will be really useful for each and everyone in this forum.

Keep posting such useful information.

Thanks for sharing and upgrading my knowledge.

Thanks and Regards
S.S.Bajoria

Feedbacks

Popular Tags

What are tags ?

Search Tags

(No tags found.)

Post Feedback

This is a strictly moderated forum. Only approved messages will appear in the site. Please use 'Spell Check' in Google toolbar before you submit.
You must Sign In to post a response.

	Next Resource: How to find size(in bytes) of all tables in a database
	Previous Resource: Get list of all columns from all tables in SQL Server
	Return to Discussion Resource Index
	Post New Resource
	Category: SQL Schema

Post resources and earn money!

Related Resources

dotNet Slackers BizTalk Adaptors Web Design

doors in nj