Technical Article

Get Foreign Key of all the tables for Sqlserver DB

This script will create two views and select the data from the TableReferences view. This view will give list of all the foreignkeys of the selected database with its constraint name, the table name and column name(s) on which the constraint is created and the referencing table name and column name(s).

(2)

You rated this post out of 5. Change rating

2006-09-25 (first published: )

610 reads

Blogs

Accept the no and move on

By

Here is a short emotional intelligence (EI) post for today, courtesy of Seth Godin....

Don’t Fight with AI

By

I was recently trying to handle a simple task with a few AI tools...

Narrow Task Decomposition in AI Pipeline Agents

By

A nightly load into sales_fact fails. Ask an orchestrating agent to break down the...

Read the latest Blogs

Forums

Alamat Kontak Bank BCA KCP Ancol Telp:(0817819444)

By Layanan_BCA_24jam

WhatsApp:0817819444 Blok A VI No, Jl. Parang Tritis Raya 3B-3C, RT.8/RW.11, Ancol, Kec. Pademangan,...

jdbc auth failing to sql from sap's cloud middleware CPI

By stan

hi , our business partner is asking s4 sap api's for receivable info and...

Searching for my own posts

By pietlinden

I have a really stupid question... Is there an easy way to search for...

Visit the forum

Question of the Day

Escaping Strings

The STRING_ESCAPE() function requires 2 parameters in SQL Server 2025. The first is a string of text and the second is the type of escape rules being used. What are the options for the second parameter?

See possible answers