Technical Article

Rename Foreign Key Constraints

This script will rename all FK constraint names in your database.  It will give them a user friendly name that can be used in error messages, etc. The FK contraint names will be formatted as FK_ChildTableName_ParentTableName_soid. Note: You first need to enable 'Allow modifications to be made directly to the system catalogs'. This can be […]

You rated this post out of 5. Change rating

2003-09-19

1,152 reads

Blogs

PostgreSQL Backup Failure

By

In this blog post I wrote a tip about fixing the PostgreSQL backup failure...

Dynamic Data Masking – SQL Server

By

Use Dynamic Data Masking to protect your data The post Dynamic Data Masking – SQL...

Using ThinOptics to Read Data

By

As I’ve aged, I find myself struggling to read many things in my life....

Read the latest Blogs

Forums

Be Careful with Missing Index Requests

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Be Careful with Missing Index...

GitHub Copilot - Our Best Ally to for T-SQL

By Daniel Calbimonte

Comments posted to this topic are about the item GitHub Copilot - Our Best...

Zero Statistics Sampling

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Zero Statistics Sampling

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers