Best Online Tutorials

SQL Tutorial

Free SQL Tutorial

SQL Interview Questions

SQL Practice Questions

SQL Tips & Tricks

SQL Errors

SQL Books

Angular Tutorial

Free Angular Tutorial

Angular Interview Questions

Angular Practice Questions

Angular Tips & Tricks

Angular Errors

Angular Books

Node.js Tutorial

Free Node.js Tutorial

Node.js Interview Questions

Node.js Practice Questions

Node.js Tips & Tricks

Node.js Errors

Node.js Books

React.js Tutorial

Free React.js Tutorial

React.js Interview Questions

React.js Practice Questions

React.js Tips & Tricks

React.js Errors

React.js Books

SSIS Tutorial

Free SSIS Tutorial

SSIS Interview Questions

SSIS Practice Questions

SSIS Tips & Tricks

SSIS Errors

SSIS Books

SEO Tutorial

Free SEO Tutorial

SEO Interview Questions

SEO Practice Questions

SEO Tips & Tricks

SEO Errors

SEO Books

Javascript Tutorial

Free Javascript Tutorial

Javascript Interview Questions

Javascript Practice Questions

Javascript Tips & Tricks

Javascript Errors

Javascript Books

MongoDB Tutorial

Free MongoDB Tutorial

MongoDB Interview Questions

MongoDB Practice Questions

MongoDB Tips & Tricks

MongoDB Errors

MongoDB Books

Next.js Tutorial

Free Next.js Tutorial

Next.js Interview Questions

Next.js Practice Questions

Next.js Tips & Tricks

Next.js Errors

Next.js Books

Error Messages (Msg 1781): Column already has a DEFAULT bound to it.  

Pooja Goel  |   Jan 4, 2020  |  Views: 162

Description:

Let’s suppose you have created below table in SQL Server by using given query.

 

CREATE TABLE [dbo].[CustomerDetail] (
[CustomerID]     INT NOT NULL IDENTITY(1, 1),
[FirstName]    VARCHAR(50),
[LastName]     VARCHAR(50),
[IsActive]     BIT DEFAULT(1)
)

 

Now you are executing the below mentioned query.

 

ALTER TABLE CustomerDetail ADD Constraint
df_Active Default 0 for
IsActive

 

 

Error Message:

But getting the below error. 



Msg 1781, Level 16, State 1, Line 2
Column already has a DEFAULT bound to it.
 

 

Causes:

In above SQL statement, you are attempting to add default constraint to a column when one default constraint already exists so you are getting the above error.

 

Solution of the Error:


You have to follow below steps.

 

Step 1: To drop existing default constraint, you need to check constraint name .it can be determined using the given statement.

 

EXECUTE [dbo].[sp_helpconstraint] 'CustomerDetail'

 

Step 2: The [dbo].[sp_helpconstraint] statement returns list of constraint type for table “CustomerDetail”, You can drop existing default constraint using the given statement.

 

ALTER TABLE CustomerDetail DROP Constraint DF__CustomerD__IsAct__41B8C09B

 

Step 3: Now new default constraints can be associated to column using given statement.

 

ALTER TABLE CustomerDetail ADD Constraint df_Active Default 0 for IsActive

 

 

 

 


Comments:
Content Contributor
Pooja Goel

Pooja Goel

Sr. Software developer at Damco Solutions Pvt. Ltd.  |   Noida, Uttar Pradesh, India

I am a sr. software developer working on technologies like SQL, SSIS, SSRS, DB2,Tableau, ASP.NET having 7 years of experience.


Read related articles

Want to sell your software ?-

If you want to sell your readymade software to the genuine clients or businessman, list your software with details and demo links.

  • Sell ERP
  • Sell Website Clones
  • Sell App Clones
  • Sell Readymade Portals
  • Sell Readymade Websites
  • Sell Mobile Apps
  • Sell Window Apps

Clients will find it using our advanced search filter and will contact you directly.

No any charge for the product lsiting.

Do you own a Company ?+

Property.sale

Buy or Sell Commercial Property+

Are you a freelancer ?+

Looking for a job ?+

Are you a Service Provider ?+

Are you a blogger ?+

Do you own an IT Institute ?+



Property.sale