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,163 reads

Blogs

Free PostgreSQL Performance Monitoring with pgNow

By

I’ve been putting together a new PostgreSQL session called “Performance Monitoring for the Absolute...

Dealing with Changing Data Formats: Schema Drift in Azure Data Factory

By

(2025-Feb-12) I will jump straight to the problem statement without a "boring" introduction, which, in...

Adding Manual Relationships Between Tables in the TDM Subsetter

By

I wrote about getting the Redgate Test Data Manager set up in 10 minutes...

Read the latest Blogs

Forums

SSL Certificate Chain

By suchit.d@promantia.com

SSL Certificate Chain Not Trusted Error in SQL Server Connection in Power BI I’m...

SSL Certificate Chain Not Trusted Error in SQL Server Connection in Power BI

By suchit.d@promantia.com

I’m encountering an SSL certificate chain issue when trying to connect to my SQL...

How Much Linux Do You Need?

By Steve Jones - SSC Editor

Comments posted to this topic are about the item How Much Linux Do You...

Visit the forum

Question of the Day

Precision and Scale II

What is the precision, scale, and length for an int variable?

See possible answers