Read SQL and extract column name with table name

[swapnilm]

Let's say I have the below SQL which have multiple tables

Eg below:

SELECT p.ProductID, p.ProductName,c.CategoryName
FROM Products p
INNER JOIN Categories c ON p.CategoryID = c.CategoryID;

Am expecting the output to be on two columns column name and their respective table name.

Column Name.   Table Name
ProductID             Products
ProductName.     Products
CategoryName.  Categories

 

[alexnajm]

Your SQL statement is going to pull through actual data - three columns called ProductID, ProductName, CategoryName. If you want the metadata about the column names and table names, check out how to do it in the technology of your choice

[alexnajm]

For example, 

• How can I get column names from a table in SQL Server? - Microsoft Q&A
• How can I get column names from a table in SQL Server? - Stack Overflow
•