how to find duplicate default constraints in a table ,example DF_abc1 is a default constraint FOR column Effective date and again DF_efg1 is also a default constraint FOR same column Effective date,Now i have a scenario where i want to find the all duplicate default constraints on all the tables in a database, does anybody have any script for this .
Perhaps your question is worded strangely, but you can't have duplicate default constraints for a column in a table. So you wouldn't need to look for duplicates.
If you're looking for default constraints with the same name across a number of tables then
sqlnaive's answer is what you want.