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