Monday, May 24, 2021

Retrieve all Table detail from Known Column in SQL Server

This query will return all COLUMNS and their associated TABLES for a given column name.

It is designed to show you what are the tables (unknown) contain a specified column (known)

SQL Code:

USE AdventureWorks2017

SELECT AS ColName, AS TableName
sys.columns c
JOIN sys.tables t ON c.object_id = t.object_id
WHERE LIKE 'Departmentid' --provide known column name here


Related Article:

No comments:

Post a Comment