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 […]

2003-09-19

1,142 reads

Blogs

Daily Coping 17 May 2022

By

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

Storage Field Day 23 – HammerSpace

By

I am thrilled to have been a part of this year’s Storage Field Day...

Daily Coping 16 May 2022

By

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

Read the latest Blogs

Forums

Migration of Data from one Database to Multiple Databases

By vamshi.sql

Hello, I have a requirement to migrate the data from existing AWS RDS DB...

AWS Beginner questions

By cariebens

I'm having some trouble wrapping my head around the relationship between EC2 instances and...

How to get weekly and Monthly view from daily in sql server

By Krish319

Hello All, I have a table like below. I need to get daily,weekly and...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers