QuestionAsk A New QuestionRenaming all constraint names with user defined names

Question

Hello,

How do I query the database for all types of constraints such as Primary Key,Foreign Key, Unique Key, and Default Constraint, and rename its system generate name to a name in following format:

- PK<TableName>_ColumnName1_ColumnName2
- FK<TableName>_ColumnName1
- UK<TableName>_ColumnName1_ColumnName2
- DF<TableName>_ColumnName1

Answer 1

Please refer http://blog.sqlauthority.com/2007/09/16/sql-server-2005-list-all-the-constraint-of-database-find-primary-key-and-foreign-key-constraint-in-database/

---

Thanks
Manish

Please use Marked as Answer if my post solved your problem and use Vote As Helpful if a post was useful.